
December 18th, 2003, 10:16 AM
|
|
Junior Member
|
|
Join Date: Dec 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
I had written this:
SELECT GroupNumber, FirstName, LastName, Initial, Address1,
City, State, ZipCode, SSN, 2 AS Code
FROM tblDataModifier
WHERE Address1 NOT LIKE '%1%' and Address1 NOT LIKE '%2%' and Address1 NOT LIKE '%3%' and Address1 NOT LIKE '%4%' and Address1 NOT LIKE '%5%' and Address1 NOT LIKE '%6%' and Address1 NOT LIKE '%7%' and Address1 NOT LIKE '%8%' and Address1 NOT LIKE '%9%' and Address1 NOT LIKE '%0%'
And it worked but it appears what you have suggested is the simple and more efficient way to go.
Thank you so very much.
I let you know how it works.
Noe
|