>hi
>what is the best/ quickest way to check if a record exists in a table? thats all I want to know, ie "select from mytable where myid =lcid " and myId is not a primary key
>thanks
>stuart

IF EXISTS (select 1 from myTable where myID = @PassedID)
-- Record Exists