Tuesday, December 29, 2009

SQL Function Reference:Oracle vs.SQL Server vs. My SQL Part- II

Leave a Comment
String Functions

Function - Convert character to ASCII
Oracle - ASCII
SQL Server - ASCII
My Sql - ASCII

Function -String concatenate
Oracle - CONCAT
SQL Server - (expression + expression)
My Sql - CONCAT

Function -Convert ASCII to character
Oracle - CHR
SQL Server - CHAR
My Sql - CONCAT

Function -Return starting point of character in character string (from left)
Oracle - INSTR
SQL Server - CHARINDEX
My Sql - INSTR

Function -Convert characters to lowercase
Oracle - LOWER
SQL Server - LOWER
My Sql - LOWER

Function -Convert characters to uppercase
Oracle - UPPER
SQL Server - UPPER
My Sql - UPPER


Function -Pad left side of character string
Oracle - LPAD
SQL Server - N/A
My Sql - LPAD

Function -Remove leading blank spaces
Oracle - LTRIM
SQL Server - LTRIM
My Sql - LTRIM


Function -Remove trailing blank spaces
Oracle - RTRIM
SQL Server -RTRIM
My Sql - RTRIM

Function -Starting point of pattern in character string
Oracle - INSTR
SQL Server -PATINDEX
My Sql - INSTR

Function -Repeat character string multiple times
Oracle - RPAD
SQL Server -REPLICATE
My Sql - RPAD

Function -Phonetic representation of character string
Oracle - SOUNDEX
SQL Server -SOUNDEX
My Sql - SOUNDEX

Function -String of repeated spaces
Oracle - RPAD
SQL Server -SPACE
My Sql - RPAD

Function -Character data converted from numeric data
Oracle - TO_CHAR
SQL Server -STR
My Sql - Need To Update

Function - Substring
Oracle - SUBSTR
SQL Server -SUBSTRING
My Sql - MID

Function - Replace characters
Oracle - REPLACE
SQL Server -STUFF
My Sql - REPLACE

Function - Capitalize first letter of each word in string
Oracle - INITCAP
SQL Server -N/A
My Sql - Need To Update

Function - Translate character string
Oracle -TRANSLATE
SQL Server -N/A
My Sql - Need To Update

Function - Length of character string
Oracle -LENGTH
SQL Server - DATALENGTH or LEN
My Sql - LENGTH

Function - Greatest character string in list
Oracle -GREATEST
SQL Server - N/A
My Sql - Need To Update

Function - Least character string in list
Oracle -LEAST
SQL Server - N/A
My Sql - Need To Update

Function - Convert string if NULL
Oracle -NVL
SQL Server - ISNULL
My Sql - Need To Update

Visit Part III (Date Functions)

0 comments: