SQL Query - Append ZERO's in front of column with keeping equal field characters
Posted on 2013-01-21
My dearest experts,
I have a table in which I have an Account Number ranging anywhere from 3 to 16 digits. I'm using this table as part of a VIEW to extract data to push into another program. I need to append "0"'s (zero's) to the front of all of the account numbers that are not 16 characters in length.
Example: 554433 needs to be 0000000000554433
Example: 87651234 needs to be 0000000087651234
Any and all assistance would be greatly appreciated.