Re: ssn test in SQL/PLSQL

What does 'valid ssn number' mean?

You can use CHECK constraints to handle format/data type checks, but if you mean checking the validity of the SSN then you need some source of valid numbers against which to check the field contents...

More details please,

Bob <bookouri_at_my-deja.com> wrote:

>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.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Nov 09 1999 - 08:54:19 CST