Thanks Sergey, but I want a more general (accepted by other DMSs, not only MS SQL Server) method, and don't want to rely on specific features.

Regards,

Fernando

SELECT CASE WHEN EXISTS ( 
		SELECT * FROM pubs..authors WHERE au_id = '213-46-8915') THEN 1  
	ELSE 0 END