One last before the week end

How do you translate into T-Sql :
TO_CHAR(Value,'99099')
Thanks for your help.Anobody for help ?|||what is Value, a date? have a look at CAST and CONVERT (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp)|||The value is a number.

TO_CHAR(12345,'99099')

I've had a look at Cast and Convert but I can't find an equivalent style anywhere.
So maybe there's another way to translate it...sql