dws
字符串函数
更新时间:2020/04/21 GMT+08:00
CHAR函数
输入:CHAR
1 | CHAR( expression1 )
|
输出
1 | LENGTH( expression1 )
|
CHARACTERS函数
输入:CHARACTERS
1 | CHARACTERS( expression1 )
|
输出
1 | LENGTH( expression1 )
|
INDEX
输入:INDEX
1 2 3 | SELECT INDEX(expr1/string, substring)
FROM tab1
WHERE … ;
|
输出
1 2 3 | SELECT INSTR(expr1/string, substring)
FROM tab1
WHERE … ;
|
STRREPLACE
输入:STRREPLACE
1 2 3 | SELECT STRREPLACE(c2, '.', '')
FROM tab1
WHERE ...;
|
输出
1 2 3 | SELECT REPLACE(c2, '.', '')
FROM tab1
WHERE ...;
|
OREPLACE
输入:OREPLACE
1 2 3 | SELECT OREPLACE (c2, '.', '')
FROM tab1
WHERE … ;
|
输出
1 2 3 | SELECT REPLACE(c2, '.', '')
FROM tab1
WHERE … ;
|
父主题: Teradata语法迁移
