Contains Any Numbers?

M

Matt Lockamy

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
 
D

Dirk Goldgar

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.
 
Top