Return Boolean Value on SQL Select Statement

October 20, 2022 by Tarik

What you have there will return no row at all if the user doesn’t exist. Here’s what you need:

SELECT CASE WHEN EXISTS (
    SELECT *
    FROM [User]
    WHERE UserID = 20070022
)
THEN CAST(1 AS BIT)
ELSE CAST(0 AS BIT) END