SQL Add Leading Zeros
The following post provides a few examples of how to add leading zeros to CHAR, VARCHAR and INT data type field values. I have to use these techniques quite often in my data world, so I figured it was a good post to share with others struggling with this task. Unfortunately, these techniques often result … Read more