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 |