Thursday, July 14, 2011

Padding character before a string in sql query

select right(replicate(@padchar, @len) + @str, @len)
e.g. select right(replicate('0', 10) + 'hell boy', 10)

No comments:

Post a Comment