数字前补齐零的SQL范本
SELECT repeat('0',(4-length(CAST(dmdordnum AS varCHAR(4)))))+CAST(dmdordnum AS VARCHAR(4)) FROM PUB.UDPEGDMDMST
数字前补齐零的SQL范本
SELECT repeat('0',(4-length(CAST(dmdordnum AS varCHAR(4)))))+CAST(dmdordnum AS VARCHAR(4)) FROM PUB.UDPEGDMDMST