function instead of lpad

[557]

can you tell me the function in sql server which serves the purpose of lpad of oracle

in oracle, lpad(x , 5 , '0') would return x always as a string of length 5 characters even if it's original length is lesser. 0 will be appended to it's left if it is of shorter lenght

 

[hmckillop]

You can do this using REPLICATE
e.g.

declare @x int
set @x = 10 --you want to return 00010
select replicate('0', 5 - len(@x)) + convert(varchar, @x)

not as tidy as lpad but does the same output



"I'm living so far beyond my income that we may almost be said to be living apart