String function operate on binary data, character strings, and expressions. The string functions are:
Function |
ASE |
ASA |
ASIQ |
dir_con |
db2 |
|---|---|---|---|---|---|
ascii |
Y |
Y |
N |
C |
N |
char |
Y |
Y |
N |
C |
N |
charindex |
Y |
Y |
N |
C |
N |
char_lengt |
Y |
Y |
N |
C |
N |
difference |
Y |
Y |
Y |
C |
N |
lower |
Y |
Y |
Y |
C |
N |
ltrim |
Y |
Y |
Y |
C |
N |
patindex |
N |
N |
N |
N |
N |
replicate |
Y |
Y |
N |
C |
N |
reverse |
Y |
N |
N |
Y |
N |
right |
Y |
Y |
Y |
C |
N |
rtrim |
Y |
Y |
Y |
C |
N |
soundex |
Y |
N |
Y |
C |
N |
space |
Y |
Y |
N |
C |
N |
str |
Y |
Y |
N |
C |
N |
stuff |
Y |
Y |
N |
C |
N |
substring |
Y |
Y |
Y |
C |
N |
upper |
Y |
Y |
Y |
C |
N |
