>Strange, I never considered using PADL(), PADR(), PADC() on anything but strings, just never occured to me that you could use numbers even though the help correctly states it can be any expression type but Logical/General.
The following is good for as long as the total number of characters used in the value does not exceed 20. Fabio mentioned the use of CAST(), which I thought about last night but wasn't able to figure out the proper syntax, which might be better to fit all possibilities.