Page 1 of 1

Query on a special character ??

Posted: Wed Oct 23, 2002 1:20 pm
by net4ward
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?

=> RE: Query on a special character ??

Posted: Thu Oct 24, 2002 6:55 am
by kfleming
You put a / in front of the * to treat it as a literal rather than a special character.____Kathleen__R&R Support