How do I query or filter for the ampersand (&) in a text field?

[kilroyscarnival]

I have tried just adding the *&* to the query or or filter criteria, but it seems to parse it to "*" & "*". I have a list of television programs and wanted to be able to filter out the sports events, most of which are listed as "METS&CUBS" and so forth. I suppose I could do this manually in Excel but I'm wondering whether there's a workaround. It would have to be filtering for the ampersand in the midst of text, not at the end or beginning of a text string.

Any thoughts on this?

Best regards,

Ann

 

[Newman]

We often write this:
like *word*
to get it automaticly changed to:
like "*word*"

But it doesn't work with the ampersand.
You should write it like that instead:
like "*&*"

 

[kilroyscarnival]

Thank you! I'll try that, but it makes sense, and I was just missing the understanding of how to put that together. Thank you for your reply.

-- Ann

 

[kilroyscarnival]

It worked!

Of course, I forgot the part where even some of the movie titles contained ampersands, so I still had to eyeball the results. But thanks again for the tip. : )