1、replace函数
语法:replace(obj,search,replace)
含义:将obj中所有search替换为replace
示例:去掉字符串ABCDEFGHIJKL的后三位
select replace('ABCDEFGHIJKL',right('ABCDEFGHIJKL',3),'')
运行结果:
2、trim函数
语法:trim([{LEADING|TRAILING|BOTH} [replace_str] from] str)
含义:去掉字符串前面|后面|前后面指定的字符串
示例1:去掉字符串EFGABCDEFG前面的EFG
select trim(LEADING 'EFG' FROM 'EFGABCDEFG')
运行结果:
示例2:去掉字符串EFGABCDEFG后面的EFG
select trim(TRAILING 'EFG' FROM 'EFGABCDEFG')
运行结果:
示例3:去掉字符串EFGABCDEFG前后的EFG
select trim(BOTH 'EFG' FROM 'EFGABCDEFG')
运行结果: