Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

select only records with Alpha characters 1

Status
Not open for further replies.

mdlaugh1

Technical User
Jan 17, 2006
76
US
I have a csv file I have imported into Access. All fields are TEXT. I need to limit the list to only records that have Alpha characters in 'Field5'. The values in 'Field5' contain a mixture of alpha/numeric characters. for example:
021577560
200812345
12201992JW
0002244
09151975AD

In the above list I want to select only records 3 & 5 (having JW or AD). Does anyone have any suggestions on this? I tried sorting the field, but that does not help. I am building a criteria field with a formula of:
like("*A*") or like ("*B*") or like ("*C*") -- but surely there's a better way..

thank you!

 
How about:

Code:
SELECT CSV.Field1
FROM CSV
WHERE CSV.Field1 Like "*[a-z]*"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top