Posted by Cimode on 05/29/06 13:27

Something like this may help...Assuming your column name is COLUMN1 and
COLUMN1 has a numeric type.

select case
when COLUMN1 < 10 then '0' + cast(COLUMN1 as varchar(10))
end
when COLUMN1 > = 10 then cast(COLUMN1 as varchar(10)) end
.......(rest of your statement...)

Hope this helps...

• Next in forum: Re: How can I conserve the initial zero when convert numeric to string using STR()
• Prev in forum: Re: SQL syntax question
• Thread view: Re: How can I conserve the initial zero when convert numeric to string using STR()

[Reply to this message]