Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering Text fields that contain numbers

Status
Not open for further replies.
MartinF

MartinF

Technical User
Sep 19, 2000
143
FR
Hi,

I need to write a query that can filter out on a text field records that contain a number anywhere within the string.

Thanks
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
794
serino
serino
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
455
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Create query that will divide work among employees 1
Replies
7
Views
256
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Find records containing another field value 1
Replies
9
Views
273
Andrzejek
Andrzejek
teach314
  • Locked
  • Question
Finding records that have no values in common 1
Replies
2
Views
112
teach314
teach314

Part and Inventory Search

Sponsor

Back
Top