Hello!

I would like to convert a int to a varchar with a specific format.
For exemple:
- 67 result in the varchar 0067
- 125 result in the varchar 0125
- 2345 result in the varchar 2345

If anyone knows a easy way to do this without using cases I would appreciate.

Thanks.

Regards,
Fernando
Edit/Delete Message

/* Good for positive numbers only. */

select field1, "Positives Only" =
right( replicate("0", 12) + convert(varchar, field1), 12)
from tempdb..Numbers where field1 > -1
go
field1 Positives Only
----------- --------------
1000 000000001000
0 000000000000

(2 rows affected)

/* Good for positive and negative numbers. */


select field1, "Both Signs" =
substring( "- +", (sign(field1) + 2), 1) +
right( replicate("0", 12) + convert(varchar, abs(field1)), 12)
from tempdb..Numbers
go

"Fernando Silva" <famls (AT) zmail (DOT) pt> wrote