Padding a string in tSQL

Gotcha There isn’t a Pad Left or Pad Right function in tSQL. Solution There is a lengthy discussion about this topic already on Stack Overflow here:¬†

C# String PadLeft() and PadRight()

This has been an irritating method to use especially when you don’t use it too often. Here are some tips about using PadLeft() and PadRight(). First off it is not a static method, you need an in...