>>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 0= (select count(*) from mytable where myfield='myvalue')
>insert into mytable (field1,field2,field...) values (value1,value2,value3...)
>else
>RAISEERROR


Thanks William