String Functions
Function - Convert character to ASCII
Oracle - ASCII
SQL Server - ASCII
My Sql - ASCII
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)
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
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)
No comments:
Post a Comment