Format A string

[besto1a]

I have a some strings some 9 charactors long and some 10 long.

I need all my strings to be 12 didgets long, so I need to add "00" to the front of my 10 didget strings and "000" to my 9 didget string

Is there any kind of format funtion to do this

Thanks

 

[Jamfool]

DECLARE @tbl_numbers TABLE
(
mynumbers varchar(12)
)

insert into @tbl_numbers values ('12345678')
insert into @tbl_numbers values ('12345678')
insert into @tbl_numbers values ('123456789')
insert into @tbl_numbers values ('123456789')


declare @reqsize int
set @reqsize = 12

select replicate('0',@reqsize-len(mynumbers)) + mynumbers from @tbl_numbers

 

[r937]

select right('0000'+mystring,12)

r937.com | rudy.ca