Finding Numerics in a field

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
 
F

fredg

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]*"
 
J

John W. Vinson

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.
 

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

Excel Comparing two columns 1
Need query to fill in missing data on table 1
Combining firstname and lastname in combo box 6
Text Trim function 7
Join rows into one long row 4
Combining relative information in feilds. 1
Converting a text date to normal date in a query 7
FIRST NAME LAST NAME 10

Top