| Convert Character to ASCII |
ASCII(p) |
ASCII(p) |
| Convert ASCII to Character |
CHR(p) |
CHAR(p) |
| Concatenate Strings |
CONCAT(p1, p2) |
p1 || p2 or p1 + p2 |
| Return Starting Point of Character in Character String |
INSTR(p1, p2) |
CHARINDEX(p2, p1) |
| Convert String to All Lower Case |
LOWER(p1) |
LOWER(p1) |
| Convert String to All Upper Case |
UPPER(p1) |
UPPER(p1) |
| Pad Left Side of Character String |
LPAD(p1, p2, p3) |
RIGHT(REPLICATE(p3, p2) + p1, p2) |
| Remove Leading Blank Spaces |
LTRIM(p1) |
LTRIM(p1) |
| Remove Trailing Blank Spaces |
RTRIM(p1) |
RTRIM(p1) |
| Return Starting Point of Pattern in Character String |
INSTR(p1, p2) |
PATINDEX(p2, p1) |
| Pad Right Side of Character String |
RPAD(p1, p2, p3) |
LEFT(p1 + REPLICATE(p3, p2), p2) |
| Phonetic Representation of Character String |
SOUNDEX(p1) |
SOUNDEX(p1) |
| Convert Numeric Data to String |
TO_CHAR(p1) |
CAST(p1 as VARCHAR) |
| Extract a Portion of a String from the Input String |
SUBSTR(p1, p2, p3) |
SUBSTRING(p1, p2, p3) |
| Replace Characters |
REPLACE(p1, p2, p3) |
REPLACE(p1, p2, p3) |
| Reverse String |
REVERSE(p) |
REVERSE(p) |
| Capitalize First Letter of Each Word in String |
INITCAP(p1) |
Not Available |
| Translate Character String |
TRANSLATE(p1) |
Not Available |
| Return Length of String |
LENGTH(p) |
LENGTH(p) |
| Return Length of String in Bytes |
LENGTHB(p) |
DATALENGTH(p) |
| Greatest Character String in List |
GREATEST(p1, p2, ...) |
GREATEST(p1, p2, ...) |
| Least Character String in List |
LEAST(p1, p2, …) |
LEAST(p1, p2, …) |
| Replace String if NULL |
NVL(p1, p2) |
ISNULL(p1, p2) |
| Return NULL if both Expressions are the Same. |
NULLIF(p1, p2) |
NULLIF(p1, p2) |