Ispirer Migration Knowledge Base

SQL Server - SQL Functions Mapping to Other Databases

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

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