>Hi Sergey,
>
>>The fastest way to check if record or records exist in Sql Server is to use EXISTS operator.
>>
SELECT CASE WHEN EXISTS (
>> SELECT * FROM pubs..authors WHERE au_id = '213-46-8915') THEN 1
>> ELSE 0 END
>
>The problem is, he wants to have a solution that can be used with most DB servers. AFAIK "CASE" is not supported on some (or many?) systems (Ingres for example).
>
H Armin,
Hi also wants it to be fast which may or may not be achived with generic approch.
--sb--