How To Query A Wildcard Character (1 Viewer)

[Learn2010]

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.

 

[arnelgp]

Enclosed in square bracket:

Like "*[*]*"

 

[Learn2010]

That was it. Thanks.