Error in updating a record

[diulmisse]

I have a table \[code\]ProjectIDProjectNameProject description\[/code\]Project Name is required to be unique. To implement the unique logic, i am sending the name of the project name to Stored Procedure as \[code\]Create proc CheckName@Project Nameasbeginselect count(ProjectName)where ProjectName=@Project Name\[/code\]it return count to CS page and i check that as if(count>0) { //Add }This code works fine with addition. Now when i want to update the project description field, the check for Project Name again goes and it return Count 1 (which is obvious) and display Project Name already exist and i am not able to update other field of the table.What other Logic can be implemented to maintain the unique field in the table. Thanks for any assistance.