CONNX Data Integration Suite
14.8.0 |
Reference Guide
|
SQL Grammar
|
SQL String Functions
|
Quick Links to SQL String Functions
Quick Links to SQL String Functions
"A" to "C"
ASCII(string_exp)
BIT_LENGTH(string_exp)
CHAR_LENGTH(string_exp)
CHARACTER_LENGTH(string_exp)
CHR(code)
CONCAT(string_exp1, string_exp2)
"D" to "I"
DIFFERENCE(string_exp1, string_exp2)
HEX(numeric_expr)
INSERT(string_exp1, start, length, string_exp2)
"L"
LCASE(string_exp)
LEFT(string_exp, count_exp)
LENGTH(string_exp)
LOCATE(string_exp1, string_exp2[, start])
LTRIM(string_exp)
LTRIMWHITESPACE(string_exp)
"O" to "P"
OCTET_LENGTH(string_exp)
POSITION(string_exp IN string_exp)
"R"
REMOVENULL(string_exp)
REPEAT(string_exp, count)
REPLACE(string_exp1, string_exp2, string_exp3)
RIGHT(string_exp, count)
RTRIM(string_exp)
RTRIMWHITESPACE(string_exp)
"S" to "U"
SUBSTRING(string_exp, start, length)
SOUNDEX(string_exp)
SPACE(count)
TRIM(string_exp)
TRIMWHITESPACE(string_exp)
UCASE(string_exp)