Query on a special character ??

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
net4ward
Posts: 7
Joined: Tue Oct 10, 2017 12:44 pm

Query on a special character ??

Post by net4ward » Wed Oct 23, 2002 1:20 pm

I cannot remember how to do this.____I have a field that is sometimes filled with the ^*^ asterisk character. In my query, I want to exclude the records where the field equals "*".____The problem is the query assumes I am looking for a wild-card.____How does one get around this and tell R&R to use the literal character to match?

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Query on a special character ??

Post by kfleming » Thu Oct 24, 2002 6:55 am

You put a / in front of the * to treat it as a literal rather than a special character.____Kathleen__R&R Support

Post Reply