Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ssn test in SQL/PLSQL

ssn test in SQL/PLSQL

From: Bob <bookouri_at_my-deja.com>
Date: Mon, 08 Nov 1999 20:51:14 GMT
Message-ID: <807d41$i91$1@nnrp1.deja.com> 





Does anyone have a procedure/function to test a char field for a valid
SSN number.  I need to produce a text file which includes SSN for each
row, but in rows that do not have valid ssn I need to replace the
invalid data with '000000000'.



any help would be great




bob




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Mon Nov 08 1999 - 14:51:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US