Jalena Blog

SQL Server 方式

UPDATE bd_cubasdoc SET custcode = '0'+SUBSTRING(custcode,0,99) WHERE pk_areacl = '0001661000000000SMBV'

Oracle|Postgres 方式

update bd_cubasdoc SET custcode='0'||substr(custcode,0);