Return Boolean Value on SQL Select Statement

Question

How to return a boolean value on SQL Select Statement?

I tried this code:

SELECT CAST(1 AS BIT) AS Expr1

FROM [User]

WHERE (UserID = 20070022)

and only return TRUE value if the UserID exists on the table. I want it to return FALSE value if the UserID doesn't exist on the table. Thank you very much.

Answer 1

If the user doesn't exist, then they will return no row at all. 

Use the below code:

SELECT CASE WHEN EXISTS (

    SELECT *

    FROM [User]

    WHERE UserID = 20070022

)

THEN CAST(1 AS BIT)

ELSE CAST(0 AS BIT) END