SPUG: Perl shines for data validation

[Michael R. Wolf]

I just saw this as a suggestion to flag invalid phone numbers as a  
validation routine for importing into a hosted database application.

I think they were serious.

LEN(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(MobilePhone, "(", ""), ")", ""), "-",""),"  
",""),".",""),"/","")) <> 10


Eeeeekk.  SQL is not the right tool for this job.

-- 
Michael R. Wolf
     All mammals learn by playing!
         MichaelRWolf at att.net