Category: Conditional Expressions

Conditional expressions use the conditional operators to compare operands (typically, value expressions). When evaluated, conditional expressions yield a logical result (true or false), depending if  the condition is satisfied. Conditional Operators Operator Condition Being Evaluated expr = expr The values are equal. expr expr The values are not equal. expr = expr The left-hand value…
Read more

The conditional operators LIKE and = (equals) can be used to construct expressions in which the condition involves matching a value to a pattern rather than to another explicit value. The patterns are usually quoted character strings constructed using special wildcard characters in addition to literal characters. LIKE Patterns Patterns for use with the LIKE…
Read more