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 |