Hi

I want to find if a value is already in a table in SQL2005 and if it is I will raise an error .

If not I add a record.

I'm not sure what syntax to use to find if the value is already in the table.

In Fox I would have used a SEEK


Thanks


Nick