Finding Numerics in a field

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

What would be the best formula to use to find out if a field has
numbers in it.

example:

JOHN SMITH2
JOHN 9 SMITH
JOHN 201 SMITH

Thanks
 
What would be the best formula to use to find out if a field has
numbers in it.

example:

JOHN SMITH2
JOHN 9 SMITH
JOHN 201 SMITH

Thanks
Click to expand...

As the criteria on that field in a query:

Like "*[0-9]*"
 
What would be the best formula to use to find out if a field has
numbers in it.

example:

JOHN SMITH2
JOHN 9 SMITH
JOHN 201 SMITH

Thanks
Click to expand...

A criterion of

LIKE "*#*"

will find all records containing one or more digits.
 
Back
Top