| Function | Description |
|---|---|
| CAST | Converts a value (of any type) into a specified datatype |
| COALESCE | Returns the first non-null value in a list |
| CONVERT | Converts a value (of any type) into a specified datatype |
| CURRENT_USER | Returns the name of the current user in the SQL Server database |
| IIF | Returns a value if a condition is TRUE, or another value if a condition is FALSE |