Find records containing special characters in a field

D

DudeGenius

I need to find any records in a table where the name field has any character
that is neither a letter nor a comma. Is there an easier way to do this than
putting a string of likes in the criteria field?
 
K

KARL DEWEY

You said 'field name' but I think you meant 'field data'.
Try this --
Not Like "*[a-z]*" AND Not Like "*,*"
 
J

John Spencer

Karl,
I don't think that will give you the results you expect.

If the field was J2x the first criteria would be False since there is a
letter in the field. So the record would be excluded from the results.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
K

KARL DEWEY

I did not test it before posting.
--
KARL DEWEY
Build a little - Test a little


John Spencer said:
Karl,
I don't think that will give you the results you expect.

If the field was J2x the first criteria would be False since there is a
letter in the field. So the record would be excluded from the results.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


KARL said:
You said 'field name' but I think you meant 'field data'.
Try this --
Not Like "*[a-z]*" AND Not Like "*,*"
 

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

Top