Adding zero to single digit number

[jfgonzalez]

I've looked in all the available resources and I can't find the solution for what seems to be a simple command -- how to add a '0' before a single digit number (i.e., 01, 02, 03, etc).

I've tried various cast and convert commands but get numerous errors. This is really driving me insane.

 

[JamesLean]

SELECT '0' + CONVERT(varchar(1), int_value)

--James