Or, if you prefer (assuming no parameters)
CREATE VIEW IsRowThere AS
SELECT CASE WHEN Row_Count >0 THEN 'True' ELSE 'False' END As ItsThere
FROM
(SELECT COUNT(*) AS row_Count FROM Sometable Where SomeConditions) x
GO
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability