| DATALENGTH (Binary String) | binary string length. |
| LEN (Binary String) | binary string length. |
| ASCII | returns the unicode code point of a character. |
| CHAR | returns the unicode character specified by code point. |
| CHARINDEX | returns position of a substring in a string. |
| CHARLEN | *RSQL only* string length. |
| CONCAT | concatenate strings, ignoring NULL values. |
| DATALENGTH | string length. |
| FORMAT | returns a localized string representation of a numeric or datetime value. |
| ISDATE | returns 1 if string can be parsed as date, time, or datetime. |
| ISNUMERIC | checks if expression is valid numeric value. |
| LEFT | returns left part of a string. |
| LEN | string length, excluding trailing blanks. |
| LOWER | converts to lowercase. |
| LTRIM | removes leading blanks. |
| NCHAR | returns the unicode character specified by code point. |
| REPLACE | replaces all occurrences of a substring with another string. |
| REPLICATE | replicates a string n times. |
| RIGHT | returns right part of a string. |
| RTRIM | removes trailing blanks. |
| SPACE | returns a string filled with spaces. |
| STR | formats a float value. |
| STUFF | replaces portion of a string by a substring. |
| SUBSTRING | returns portion of a string. |
| TRIM | removes leading and trailing blanks. |
| UNICODE | returns the unicode code point of a character. |
| UPPER | converts to uppercase. |
| ABS | absolute value |
| ACOS | arccosine |
| ASIN | arcsine |
| ATAN | arctangent |
| ATN2 | angular part of <x, y> coordinates |
| CEILING | ceiling |
| COS | cosine |
| COT | cotangent |
| DEGREES | degrees from radians |
| EXP | exponential function |
| FLOOR | floor |
| ISNUMERIC | checks if expression is valid numeric value. |
| LOG | natural logarithm |
| LOG10 | base-10 logarithm |
| PI | value of Pi |
| POWER | power |
| RADIANS | radians from degrees |
| RAND | returns a random number. |
| ROUND | rounds or truncates the number. |
| SIGN | sign of the number |
| SIN | sine |
| SQRT | square root |
| SQUARE | square |
| TAN | tangent |
| BOMONTH | *RSQL only* first day of month for specified date. |
| CURRENT_TIMESTAMP | local current datetime. |
| DATEADD | returns date + specified duration. |
| DATEDIFF | duration between two dates. |
| DATEFROMPARTS | creates date from the specified parts. |
| DATENAME | returns specified part of the date, as string. |
| DATEPART | returns specified part of the date, as integer. |
| DATETIME2FROMPARTS | creates datetime from the specified parts. |
| DATETIMEFROMPARTS | creates datetime from the specified parts. |
| DAY | day of the specified date. |
| EOMONTH | last day of month for specified date. |
| GETDATE | local current datetime. |
| GETUTCDATE | UTC current datetime. |
| ISDATE | returns 1 if string can be parsed as date, time, or datetime. |
| MONTH | month of the specified date. |
| SYSDATETIME | local current datetime. |
| SYSUTCDATETIME | UTC current datetime. |
| TIMEFROMPARTS | creates time from the specified parts. |
| YEAR | year of the specified date. |
| CASE | returns the first result in the list for which the condition is true. |
| CHOOSE | returns argument at position i in the list. |
| COALESCE | returns first non-NULL argument in the list. |
| IIF | if expression is true, returns a. Else returns b. |
| ISNULL | if argument is NULL, returns a replacement value. |
| NULLIF | returns NULL if the two specified expressions are equal. |
| CAST | converts argument to specified datatype. |
| CONVERT | converts argument to specified datatype. |
| FORMAT | returns a localized string representation of a numeric or datetime value. |
| STR | formats a float value. |
| RANDOM_BIGINT | *RSQL only* random bigint between two values. |
| RANDOM_DATE | *RSQL only* random date between two dates. |
| RANDOM_FLOAT | *RSQL only* random float between two values. |
| RANDOM_INT | *RSQL only* random int between two values. |
| RANDOM_NUMERIC | *RSQL only* random numeric value. |
| RANDOM_VARCHAR | *RSQL only* random ascii string of length between specified limits. |
| AVG | returns the average value of expressions. |
| COUNT | returns the count of expressions. |
| COUNT_BIG | returns the count of expressions. |
| MAX | returns the maximum value. |
| MIN | returns the minimum value. |
| SUM | returns the sum of expressions. |
| @@DATEFIRST | current DATEFIRST value |
| @@DATEFORMAT | *RSQL only* current DATEFORMAT value |
| @@ERROR | last statement error code. Is always 0. |
| @@IDENTITY | last IDENTITY value inserted |
| @@LANGUAGE | current language |
| @@ROWCOUNT | number of records affected by the last statement |
| @@SERVERNAME | machine/service name of the instance |
| @@SERVICENAME | service name of the instance |
| @@TRANCOUNT | transaction nesting level |
| @@VERSION | RSQL version |
| CURRENT_USER | current user name |
| DATABASE_PRINCIPAL_ID | user or role ID |
| DB_ID | database ID |
| DB_NAME | database name |
| OBJECT_ID | object ID |
| SCHEMA_ID | schema ID |
| SCHEMA_NAME | schema name |
| SCOPE_IDENTITY | last IDENTITY value inserted. |
| SESSION_USER | current user name |
| SUSER_ID | login ID |
| SUSER_NAME | login name |
| SYSTEM_USER | current login name |
| TYPEOF | *RSQL only* returns datatype of the argument as string. |
| USER | current user name |
| USER_ID | user or role ID |
| USER_NAME | user or role name |