Netezza Character Function | Notes |
ASCII | |
BTRIM | |
CHR | |
CONCAT | Not supported: • BIT argument • NCHAR argument • NVARCHAR argument |
DLE_DST | |
INITCAP | |
INSTR | |
LE_DST | |
LENGTH | |
LOWER | |
LPAD | Length limit of 4000. |
LTRIM | |
POSITION | Not supported: • NCHAR argument • NVARCHAR argument |
REPEAT | |
REPLACE | Not available in Netezza. Netezza has a TRANSLATE function, but it works differently. |
RPAD | |
RTRIM | |
SOUNDEX | |
SPACE | Not supported: • BIT argument |
STRPOS | |
SUBSTR | |
SUBSTRING | Not supported: • NCHAR argument • NVARCHAR argument |
TRANSLATE | |
TRIM | |
TRUNC | |
UNICHR | |
UNICODE | |
UPPER |