>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
IF you know which field to check, then
IF EXISTS (SELECT 1 FROM dbo.myTable WHERE Field = @Value)
RAISERROR ...
If it's not broken, fix it until it is.
My Blog