Leading Zeroes

[bjr149]

I have this command : convert(varchar(3),@Counter)


As i do this i want to put leading zeroes on the string.

So if counter is 5, i want it to print out 005. Thanks for the help

 

[gmmastros]

I see that you are converting to varchar, which is good. Now, simply put 3 zeros in front of the number, and then take the last 3 characters. Like this...

Declare @Counter Int
Set @Counter = 5

Select Right('000' + Convert(VarChar(3), @Counter), 3)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[bjr149]

Thank you works great.