Home Forums SQL Server 7,2000 T-SQL Pad varchar with leading zeros RE: Pad varchar with leading zeros
dj_meier
SSCrazy
Points: 2732
More actions
November 25, 2002 at 12:40 pm
#442340
If you want a generic function you could do it like this:
SET field_name = RIGHT(REPLICATE('0',5) + field_name,5)
-Dan