Number formats

Hi people,

Can anyone tell me how to pad a field which is declared as an integer (or number(38)) with zeros please? The field is always 4 digits but cannot be declared as CHAR as the Pro*C code I've got doesn't handle this. Each time I input 0005 for example, it is converted to 5 which is no good. Any suggestions would be greatly appreciated.

TIA Pilsbury Received on Mon Feb 01 1999 - 11:06:56 CST