SELECT CASE WHEN EXISTS ( > SELECT * FROM pubs..authors WHERE au_id = '213-46-8915') THEN 1 > ELSE 0 ENDThe 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).