This table shows the equivalent Microsoft® SQL Server™ function for each Oracle function.
| Function | Oracle | SQL Server |
|---|---|---|
| Convert character to ASCII | ASCII | ASCII |
| String concatenate | CONCAT(expression1, espression2) | (expression1 + expression2) |
| Convert ASCII to character | CHR | CHAR |
| Greatest character string in list | GREATEST | N/A |
| Capitalize first letter of each word in string | INITCAP | N/A |
| Returns starting point of character in character string (from left) | INSTR | CHARINDEX |
| Starting point of pattern in character string | INSTR | PATINDEX |
| Returns starting point, in bytes, of character or pattern in character string | INSTRB | N/A |
| Least character string in list | LEAST | N/A |
| Length of character string | LENGTH | DATALENGTH |
| Length of character string in bytes | LENGTHB | N/A |
| Convert characters to lowercase | LOWER | LOWER |
| Pad left side of character string | LPAD | N/A |
| Remove leading blanks | LTRIM(char) | LTRIM(char) |
| Remove other leading characters | LTRIM(char, set) | N/A |
| Capitalize first letter of each word in an NLS string | NLS_INITCAP | N/A |
| Convert characters to lowercase in an NLS string | NLS_LOWER | N/A |
| Convert characters to lowercase in an NLS string | NLS_UPPER | N/A |
| Returns the string of bytes used to sort a character | NLS_SORT | N/A |
| Convert string if NULL | NVL | ISNULL |
| Replace characters | REPLACE | STUFF |
| Pad right side of character string | RPAD | N/A |
| Remove trailing blanks | RTRIM(char) | RTRIM |
| Remove other trailing characters | RTRIM(char, set) | N/A |
| Phonetic representation of character string |
SOUNDEX | SOUNDEX |
| Character data converted from numeric data | TO_CHAR | STR |
| Returns a substring of a character string | SUBSTR | SUBSTRING |
| Returns a substring of a character string, the range to search specified in bytes | SUBSTRB | N/A |
| Translate character string | TRANSLATE | N/A |
| Convert characters to uppercase | UPPER | UPPER |