Number to String with Leading Zeros - MSSQL

Number to String with Leading Zeros - MSSQL

code snippet

mssql
select right('00000' + cast(Your_Field as varchar(5)), 5)

"What we think, we become"

Contact me!

Have questions? Feel free to use the form or send me an email with any questions.

I will be responsive to your requests and your questions.