Left Padding in TSQL 2

[MMund]

Does anyone know of a non-kludgy way in TSQL to left-pad zeros onto a numeric field to export into an SDF file?

For example,
45000 would show in the SDF file as 00045000 and 1500 would show as 00001500.

I am making the switch from FoxPro 2.6 to TSQL. In FoxPro, I had the PADL function that handled this with ease. In TSQL, I don't see anything like that.

 

[RiverGuy]

Say your total length in characters is 10. The following code will pad an INT to create a string of 10 characters:

LEFT('0000000000' + CONVERT(VARCHAR(10), YourIntColumn), 10)

 

[jbenson001]

This code alows for any legth.. I you are using ints then you can convert as in RiverGuys's code

declare @var as varchar(10)
set @var = '45000'
select right(Replicate('0',8 - Len(@var)) + @var,8)

 

[jbenson001]

Actually to allow it to be more flexible and allow for any length you want, try this:

declare @var as varchar(10)
declare @len as int

set @var = '45000'
set @len = 8

select right(Replicate('0',@len - Len(@var)) + @var,@len)