Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - What Is a Boolean Value
(Continued from previous topic...)
What Is a Boolean Value?
A Boolean value indicates a condition in a state of TRUE or FALSE.
In Transact-SQL language, there is not storage data type defined to store a Boolean value.
So Boolean values can only exist temporarily as part of the execution of Transact-SQL expression or statement.
Boolean values are returned from comparison operations.
The tutorial exercise below shows you some examples of how Boolean values are used:
-- Boolean values in a CASE expression
SELECT CASE WHEN 1>0 THEN
-- Boolean values in an IF statement
-- Stand alone Boolean value not allowed
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '>'.
(Continued on next topic...)
- What Is a Boolean Value?
- What Are Conditional Expressions?
- What Are Comparison Operations?
- How To Perform Comparison on Exact Numbers?
- How To Perform Comparison on Floating Point Numbers?
- How To Perform Comparison on Date and Time Values?
- How To Perform Comparison on Character Strings?
- What To Test Value Ranges with the BETWEEN Operator?
- What To Test Value Lists with the IN Operator?
- What To Perform Pattern Match with the LIKE Operator?
- How To Use Wildcard Characters in LIKE Operations?
- How To Test Subquery Results with the EXISTS Operator?
- How To Test Values Returned by a Subquery with the IN Operator?
- What Are Logical/Boolean Operations?