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 |