posted 21 years ago
The NUMBER data type will ignore all leading zero. If you really have to use varchar, then you can(another solution is to use 'round' function) use 'fm' in the format mask to remove the leading zeros or spaces
For eg:
zerotest table with two columns (Name varchar2(10),amount varchar2(5))
insert into zerotest values('chhaya',to_char('00234','fm99999'));
Regards
Beksy
[ August 21, 2002: Message edited by: Beksy Kurian ]