SQL - Logical Functions

SQLlogical functionsare 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 & Description1CHOSE()Returns a item from the list at the specified index value.2IIF()Returns a one of two values, depending on the boolean-expression.3NULLIF()Returns NULL if both expressions are equal.