Returns TRUE if selectExpr matches expr exactly.
Returns TRUE if the selectExpr falls inclusively within this range. The range must be specified in ascending order.
For example, if you specify 25 To 50, the corresponding group of statements is executed when selectExpr is any value between 25 and 50, inclusive. If you specify -4 to -1, the corresponding group of statements is executed when selectExpr is any value between -4 and -1, inclusive
Returns TRUE when the comparison operation for selectExpr and expr is true. The comparison operator must be one of the following: = > < <> >< <= =< >= =>.
For example, if you specify Is < 37, then the corresponding group of statements is executed when selectExpr is less than 37.