Contains Any Numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to write a query that will display certain codes if the field
contains any numbers (the field may be numeric, text or consist of a
combination of numbers and text). I would like to be able to report on how
many records 1 or more numeric characters, even though the field may also
contain text. Any help would be greatly appreciated. Thanks

Matthew Lockamy
 
Matt Lockamy said:
I'm trying to write a query that will display certain codes if the
field contains any numbers (the field may be numeric, text or consist
of a combination of numbers and text). I would like to be able to
report on how many records 1 or more numeric characters, even though
the field may also contain text. Any help would be greatly
appreciated. Thanks
Click to expand...

The expression

Like '*[0-9]*'

should return True if the field contains any numeric digit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export a query into a delimited txt 2
Query to Delete certain fields not records 1
Assigning values to text for calculation 0
Excel Sum numbers in cells that also contain text 34
Search utility 2
Red text or background if control contains a certain value? 2
Remove non numeric characters from field 4
union queries - with tables containing fields with attachments 2

Back
Top