Scalar Functions
Scalar functions return a single value based on the input parameters. Use the categories below to explore specific function groups.
| Function | Category | Description |
|---|---|---|
| LEN | String | Returns the number of characters of the specified string expression. |
| CONCAT | String | Concatenates two or more strings. |
| GETDATE | Date & Time | Returns the current database system timestamp. |
| DATEADD | Date & Time | Adds a specified number interval to a date. |
| ABS | Mathematical | Returns the absolute value of the specified numeric expression. |
| POWER | Mathematical | Returns the value of a number raised to the power of another number. |
| @@IDENTITY | System | Returns the last-inserted identity value. |
| ISNULL | System | Replaces NULL with the specified replacement value. |