#1: Validating fiels for correct input

Posted on 2008-04-16 10:01:13 by Rick Wright

GlacierHi -

I need to validate a field in my database where the user will input their
phone number. I would like to ensure that the area code is included. The
field is setup as follows:

hphone varchar(12)

What is the best way to check to see if this format 123-456-7890 is entered?
Thank you in advance for any assistance.

- Rick

Report this message