Hi all,

How do you keep leading zeros in a number(6) field? I need the leading zeros to be stored. I have the folwoing code :
UPDATE my_emp
SET SSN = LPAD(emp_no,3,0)||9999;

The script runs fine except the leading zeros are truncated because of the datatype. Is there a way to keep the leading zeros?

Thanks,