How To Query A Wildcard Character

Learn2010

Registered User.
Local time
Today, 10:14
Joined
Sep 15, 2010
Messages
415
I am exporting Excel data from a website and importing it into an Access database. Certain entities within the data are marked with an asterisk (*). For example, *Jones, *Williams, etc. I need to identify these in an update query. In the criteria field I have used Like "*", Like "**", and Like "***". This doesn't work.

What does?

Thank you.
 
Enclosed in square bracket:

Like "*[*]*"
 
That was it. Thanks.
 

Users who are viewing this thread

Back
Top Bottom