SQL – Logical Functions


SQL – Logical Functions



”;


SQL logical functions are used primarily for checking (or testing) the truth of some conditions. A logical function performs a logical operation or comparison on objects and expressions and returns a boolean value −






Sr.No. Function & Description
1 CHOSE()

Returns a item from the list at the specified index value.

2 IIF()

Returns a one of two values, depending on the boolean-expression.

3 NULLIF()

Returns NULL if both expressions are equal.

Advertisements

”;

Leave a Reply

Your email address will not be published. Required fields are marked *