Hi, try SELECT concat(REPLICATE('0', 16 - LEN(NAG)),NAG) as NAG16 where NAG is yourVarcharField and 16 is lenght that you need