>>-STRIP--(---string --expression-- + ----------------------+---)->< '
-,--+--BOTH----+--+----+---'
+--LEADING-+ +--L-------+ +--TRAILING+ '
-T---------'
B:BOTH表示两头 L:LEADING表示去头 T:TRAILING表示去尾 strip-character:表示要截去的单个字符常量
用上面的字符串举例如下:
db2 "select '
#'
||strip('
00000999000'
,b,'
0'
)||'
#'
from sysibm.sysdummy1" 1 ------------- #999# 1 record(s) selected. db2 "select '
#'
||strip('
999 '
,t,'
'
)||'
#'
from sysibm.sysdummy1" 1 ------------- # 999# 1 record(s) selected. db2 "select '
#'
||strip('
99 9 '
,t,'
'
)||'
#'
from sysibm.sysdummy1" 1 ------------- # 99 9# 1 record(s) selected. db2 "select '
#'
||strip('
00990090000'
,l,'
0'
)||'
#'
from sysibm.sysdummy1" 1 ------------- #990090000# 1 record(s) selected.