Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Thursday, November 16, 2017

Trying to convert a int @variable to a varchar @variable with leading zero.

SQLServerCentral » Latest topics
Trying to convert a int @variable to a varchar @variable with leading zero.
I am trying to create a text variable called @varnumber with a leading zero for values less that 10.  Below is my code and the result from my code is only the leading digit: I do not see the whole number. I have tried 3 different ways (two are commen

No comments: