Home Forums SQL Server 7,2000 T-SQL Pad varchar with leading zeros RE: Pad varchar with leading zeros
Antares686
SSC Guru
Points: 125444
More actions
November 25, 2002 at 6:45 pm
#442375
Or
REPLICATE('0', 5-LEN(field_name)) + field_name