Most SQL servers should support LPAD() and RPAD().
The syntax for these functions are "LPAD(string, length, pad)".
The padding is space by default, but just set it to "0" to use zeros.
SQL: Zero padding your numbers
Posted by
twig
at
2:54 PM
Sunday, February 21, 2010
Tags:
mysql,
postgres sql,
sql
