By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,073 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,073 IT Pros & Developers. It's quick & easy.

finding specified characters in text field access 2007

P: 2
I am attempting to write code or query to find any numeric value in a text field. The records will have both numeric and alpha characters but I want to comb through the records and make a list of the records with numeric values in them.

kdkendn
dkcic120
234kdslc500

as examples. so the second and third records would be pulled back. I want to do this either as query or as vb code
Nov 28 '11 #1
Share this Question
Share on Google+
2 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
In a query you can use wildcards for example:
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM myTable WHERE txFieldName like "*#*"
# is the wildcard for numeric charecter.

This will return all records where txFieldName contains a number.
Nov 28 '11 #2

NeoPa
Expert Mod 15k+
P: 31,709
Not everyone could have answered that question Pat ;-) Remember to mark the post as Best Answer when you've reviewed it.
Nov 28 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.