SQL Query

[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

 

[Steve Schapel]

Darrin

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

 

[Darrin]

Yes that is great Steve, thank you for making me think harder!