Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> including leading zero SS#
I want to include leading zeros when displaying social security numbers. this is what I have so far:
SUBSTR( cli.ssn, 1, 3 )||'-'||SUBSTR( cli.ssn, 4, 2 )||'-'||SUBSTR( cli.ssn, 6, 4 ) soc_sec
Thanks Received on Sat Jun 30 2001 - 15:27:52 CDT