Padding field in SELECT query
Posted on 2003-02-25
I want to pad the fields while selecting them in the query. The query should look like -
SELECT PAD(<field name>,10,"0") from <table name>
So if the value of the files is 12345 the query should return 0000012345. Also what would be the option if I want to right-pad ?
Is there a function for this in DB2 UDB