I want to include leading zeros when displaying social security numbers in an Oracle 8.0 database query.
I have this so far: SUBSTR( cli.ssn, 1, 3 )||'-'||SUBSTR( cli.ssn, 4, 2 )||'-'||SUBSTR( cli.ssn,6, 4 ) soc_sec
cli.ssn datatype NUMBER
Thanks.