Table of Contents


User Documentation Ispirer Capabilities - Microsoft SQL Server Migration Pricing

SQL Server - SQL Functions Mapping to Other Databases

Numeric Functions Mapping

SQL Server Oracle IBM DB2 MySQL
ABS ABS ABS ABS
ACOS ACOS ACOS ACOS
ASIN ASIN ASIN ASIN
ATAN ATAN ATAN ATAN
ATN2 ATAN2 ATAN2 ATAN2
CEILING CEIL CEILING CEILING
COS COS COS COS
COT COT COT
DEGREES DEGREES DEGREES
EXP EXP EXP EXP
FLOOR FLOOR FLOOR FLOOR
LOG LN LN LN
LOG10 LOG LOG10 LOG10
PI PI
POWER POWER POWER POWER
RADIANS RADIANS RADIANS
RAND RAND RAND
ROUND ROUND (number) ROUND ROUND
SIGN SIGN SIGN SIGN
SIN SIN SIN SIN
SQRT SQRT SQRT SQRT
SQUARE
TAN TAN TAN TAN

String Functions Mapping

SQL Server Oracle IBM DB2 MySQL
ASCII ASCII ASCII ASCII
CHAR CHR CHR CHAR
CHARINDEX INSTR LOCATE INSTR
DIFFERENCE DIFFERENCE
LEFT LEFT LEFT
LEN LENGTH CHARACTER_LENGTH CHAR_LENGTH
LOWER LOWER LCASE LOWER
LTRIM LTRIM LTRIM LTRIM
NCHAR NCHR
PATINDEX REGEXP_INSTR
QUOTENAME QUOTE
REPLACE REPLACE REPLACE REPLACE
REPLICATE REPEAT
REVERSE REVERSE
RIGHT RIGHT RIGHT
RTRIM RTRIM RTRIM RTRIM
SOUNDEX SOUNDEX SOUNDEX SOUNDEX
SPACE REPEAT
STUFF INSERT INSERT
SUBSTRING SUBSTR SUBSTR SUBSTR
UNICODE
UPPER UPPER UCASE UPPER