Hi!,
This email was created by [MemberName] <[MemberEmail]> who thought you would be interested in the following Article:
"LPAD and RPAD functions in SQL"
LPAD and RPAD function works for padding in SQL Server
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!