The following lists the SQL Server ODBC scalar functions and their ANSI equivalents.
| SQL | ANSI | Description |
|---|---|---|
| % | Mod | modulo of x base y |
| & | bitwise and | |
| ^ | bitwise exclusive or | |
| | | bitwise (inclusive) or | |
| ~ | bitwise one's complement | |
| + | Concat | concatenate two strings |
| Abs | Abs | absolute value |
| Acos | Acos | arc cosine |
| Ascii | Ascii | converts a single char to an ASCII numeric value |
| Asin | Asin | arc sine |
| Atan | Atan | arc tangent of angle |
| Atn2 | Atan2 | arc tangent of two values |
| Cast | Cast | general type conversion |
| Ceiling | Ceiling | least integer greater than or equal |
| Char | Char | converts an ASCII numeric value to a single char |
| CharIndex | Locate | searches for a substring |
| Coalesce | returns first non-null value | |
| Convert | Convert | general type conversion |
| Cos | Cos | cosine of angle |
| Cot | Cot | cotangent of angle |
| Day | DayOfMonth | numeric day of month |
| DB_Name | Database | database name |
| Degrees | Degrees | converts an angle in radians to degrees |
| Difference | Difference | fuzzy string comparison |
| Exp | Exp | natural exponentiation |
| Floor | Floor | greatest integer less than or equal |
| GetDate | Current_Timestamp | current date and time |
| GetUTCDate | current date and time in UTC | |
| IsNull | IfNull | returns first non-null value |
| Left | Left | substring from left side of a string |
| Length | Char_Length | length in characters of string |
| Log | Log | natural logarithm |
| Log10 | Log10 | base 10 logarithm |
| Lower | LCase | lowercase string |
| LTrim | LTrim | trims whitespace from left side of string |
| Month | Month | numeric month value |
| NChar | converts a Unicode numeric value to a single char | |
| Pi | Pi | value of pi |
| Power | Power | exponentiation |
| Radians | Radians | converts an angle in degrees into radians |
| Replicate | Repeat | generates n repeated characters |
| Round | Round | round to an integer value |
| RTrim | RTrim | trims whitespace from right side of string |
| Sign | Sign | arithmetic sign of value |
| Sin | Sin | sine |
| SoundEx | SoundEx | generates hash of text string |
| Space | Space | generate n spaces |
| Sqrt | Sqrt | square root |
| Square | square of the value | |
| Stuff | inserts a substring into a string | |
| SubString | SubString | middle part of string extraction |
| Tan | Tan | tangent of angle |
| Unicode | converts a single char to an Unicode numeric value | |
| Upper | UCase | uppercase string |
| User_Name | User | user name |
| Year | Year | numeric year value |