去掉字符串左边或右边指定的字符

使用trim函数。

删除左边的‘0’

select trim(leading "0" from col_name);

删除右边的‘0’

select trim(trailing "0" from col_name);

删除前后的‘0’

select trim(both "0" from col_name);