Thursday, March 15, 2012

Padding an string with a character (n times) in SQL Server



What are we cooking today?
Padding an string with a character (n times) in SQL Server

RECIPE

Declare @myString as varchar(10)
set @myString = '1234567'

select  RIGHT(REPLICATE('0', 10)
+ CAST(@mystring AS VARCHAR(10)), 10) PaddedResult

RESULT:
0001234567