用函数 replace;
或
UPDATE TABLE SET
L3 = substrB( l3, 1, 10)||:ls_bzdw||substrB( l3,instrB( l3, ' ',1))
where tbdw = :ls_tbdw;
或
UPDATE TABLE SET
L3 = substrB( l3, 1, 10)||:ls_bzdw||substrB( l3,instrB( l3, ' ',1))
where tbdw = :ls_tbdw;
2.update table set col=rtrim(col,'a')
3.update table set col=replace(substr(col,length(col)-n,n),'替换的字符');n是最后一(几)
4.跟3一样吧