Migrating Character Functions from Oracle to SQL Server

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

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.