Return Boolean Value on SQL Select Statement
boolean, select, sql
Solution
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
Problem
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 it only returns `TRUE` if the `UserID` exists on the table. I want it to return `FALSE` if the `UserID` doesn't exist on the table.