>>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 ...
Thanks Naomi