| Function | Description | Return Type | Parameter |
|---|---|---|---|
| NullIf | NULLIF returns NULL if its arguments are equal. Otherwise, it returns its first argument, scalar_expression_1. NULLIF is a shorthand expression for the following full CASE expression: CASE WHEN scalar_expression_1=scalar_expression_2 THEN NULL ELSE scalar_expression_1 END | String | String, comparison string |
| Coalesce | Returns the second argument if the first argument is null. | String | String 1, String 2 |