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

Answer 2

To return a boolean value on SQL Select Statement, refer to the below query

SELECT 

    CASE 

        WHEN condition THEN 1  -- Represents TRUE

        ELSE 0                 -- Represents FALSE

    END AS BoolValue

FROM table_name;