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

kilroyscarnival

Registered User.
Local time
Today, 13:26
Joined
Mar 6, 2002
Messages
76
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
 
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 "*&*"
 
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
 
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. : )
 

Users who are viewing this thread

Back
Top Bottom