I need a function that I can pass in
total length of output
type of padding
side of padding
In other words
Declare @string varchar(100) = 'lrbrister', @totalLength = 30, @TypePadding = '9', @SidePadding = 'R'
Then I could do the select...
Select dbo.mypad(@string,@totalLength, @TypePadding, @SidePadding) as outstring
And this would come back...
If I passed in left 9's would be to left of course