Amass

How to Left-Pad a field in MSSQL

I recently encountered a situation where I needed to left-pad a string to a certain number of characters with 0’s. This is the SQL to do it:

RIGHT('000' + rtrim(column_name),3)

The ‘000′ is your padding characters, column_name is what you’re padding, and the 3 is how many characters you want back.

This entry was posted on Wednesday, May 28th, 2008 at 9:55 am and is filed under MSSQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

« Creating arrays of strings on-the-fly
Converting a decimal from base 10 to base 62 in C# »

Leave a Reply

*
To prove you're a person (not a spam script), type the security word shown in the picture.
Anti-Spam Image