Update tbl_baseinfo SET FRegNo =
(select replace(ltrim(replace(FRegNo,'0',' ')),' ','0'))
去除头部为0的SQL
最新推荐文章于 2023-04-10 16:34:01 发布
Update tbl_baseinfo SET FRegNo =
(select replace(ltrim(replace(FRegNo,'0',' ')),' ','0'))