Integer Lowest Order

[IAMINFO]

Hello everyone ,I have a number 80505 how would I use sql to show the number as 00558, not really sure where to start. I need to apply this to multiple rows.

Thank you

 

[markros]

Try

declare @t table (Number int)
insert into @t values ( 80505),(7845203)

;with cte as (select T.number, SUBSTRING(ltrim(T.number),N.number,1) as [Digit]
from @t T
inner join dbo.numbers N on N.Number between 1 and LEN(T.number))

select c.Number as OriginalNumber, (select '' + LTRIM(digit)
from cte c1 where c1.Number = c.Number order by Digit
for XML path('')) as NewNumber
from cte c
group by c.Number
order by c.Number

I'm using existing dbo.Numbers (or Tally) table, which is very easy to create on the fly also.

PluralSight Learning Library