In this case you will need to temporaily change the SINGLE character. SET SINGLE=? Notice no spaces around the = Now search for your underscores. When done SET SINGLE=_
Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Emmitt Dove Sent: Thursday, January 31, 2008 7:22 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Finding '__' query Alastair, Try setting a variable to (CHAR(45)+CHAR(45)) and looking for the variable. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Alastair Burr Sent: Thursday, January 31, 2008 6:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Finding '__' query I am trying to find and then eliminate a realstring of two underscores in a file name. Because the underscore is the single wildcard, probably not surprisingly, I am finding far more than I want. I seem to remember that there was a way of escaping the character to force the search to find the underscores rather than any character. Can anybody remind me of how to do it, please? Thanks & regards, Alastair. ---------------------------- Alastair Burr St. Albans, UK. [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> -----------------------------

