String Functions¶
CHAR Function¶
Input: CHAR
CHAR( expression1 )
Output:
LENGTH( expression1 )
CHARACTERS¶
Input: CHARACTERS
CHARACTERS( expression1 )
Output:
LENGTH( expression1 )
INDEX¶
Input: INDEX
SELECT INDEX(expr1/string, substring)
FROM tab1
WHERE ... ;
Output:
SELECT INSTR(expr1/string, substring)
FROM tab1
WHERE ... ;
STRREPLACE¶
Input: STRREPLACE
SELECT STRREPLACE(c2, '.', '')
FROM tab1
WHERE ...;
Output:
SELECT REPLACE(c2, '.', '')
FROM tab1
WHERE ...;
OREPLACE¶
Input: OREPLACE
SELECT OREPLACE (c2, '.', '')
FROM tab1
WHERE ... ;
Output:
SELECT REPLACE(c2, '.', '')
FROM tab1
WHERE ... ;
STRTOK¶
Input
LENGTH(STRTOK(STRTOK(JOB_NAME_TADD,'-',4),'_',2))
Output:
LENGTH(split_part(split_part(JOB_NAME_TADD,'-',4),'_',2))