How do I Search for an Asterisk without Query Thinking It Is a Wild Card?

[thulot]

Hello, everyone, I am using Access 2013 64-bit on Windows 10.

A few years ago, I created a many-to-many database for my movie collection. Now, I need help creating a query, please.



Some of the movie titles have asterisks at the end of them. I did this to designate which movies are duplicates. I know I can create a check box in the form for this, but until I get around to doing that, I am using asterisks.

Now, what I want to do is create a query for every movie whose title contains an asterisk. Of course, it didn't occur to me until just now that an asterisk serves as a wild card in query searches. As a result, putting: like "*" doesn't work.

So, could anyone please tell me how to set up the query criteria so the query will recognize the asterisk as an actual item to search for, and not a wild card?

The table I am working with is called tblMovies, and the field in question is called Title.

If you need more information, please let me know. Thank you. T. Hulot

[CJ_London]

put square brackets round it

Like "*[*]*"

[CJ_London]

or use the instr function

WHERE instr(Title,"*")<>0

[thulot]

The brackets worked. Thank you.

I was dabbling and experimenting, and decided to try replacing the asterisks with plus signs. I then used Like "*+" and that worked, as well. So, now I know what to do for either character. Thanks again.