数字前补齐零的SQL范本

数字前补齐零的SQL范本

SELECT repeat('0',(4-length(CAST(dmdordnum AS varCHAR(4)))))+CAST(dmdordnum AS VARCHAR(4)) FROM PUB.UDPEGDMDMST