SQL Query

  • Thread starter Thread starter Darrin
  • Start date Start date
D

Darrin

Hey all, I am having trouble with selecting data.

I have a text field that holds info such as "12345" and "1ABNFGD". These
values are always changing.

My questions is, How do I create a slect query to only pick up the fields
that have the mix of numbers and letters.

Any help
 
Darrin

One way would be to use a criteria in this field like this...
Like "*[A-Z]*" And Like "*[0-9]*"
 
Back
Top