finding specified characters in text field access 2007

[Pat Bolen]

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

[TheSmileyCoder]

In a query you can use wildcards for example:

SELECT * FROM myTable WHERE txFieldName like "*#*"

# is the wildcard for numeric charecter.

This will return all records where txFieldName contains a number.

[NeoPa]

Not everyone could have answered that question Pat ;-) Remember to mark the post as Best Answer when you've reviewed it.