How do you keep leading zeros in a number(6) field? I need the leading zeros to be stored. I have the folwoing code :
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?