Re: Verifying A Column contents
>Does anyone know of an easy (one time only) using SQL or ESQL to check
to
>see if the value in a Char(30) is anything other then an Alpha
character.
>
>I have a large name table and I need to find any first or last name
that has
>non-alpha characters so that they can be reviewed.
How about
SELECT *
FROM tablename
WHERE firstname MATCHES "*[!"'$%^&*()_+`-={};:'@#~,./<>?0-9]*"
OR lastname MATCHES "*[!"'$%^&*()_+`-={};:'@#~,./<>?0-9]*"
? :-)
--
"I'll Be Back"
Obnoxio
************************************************
Sane? Hell, if I was sane, why would I be here?
Get Your Private, Free Email at http://www.hotmail.com