String search and match with ()

Hi all,

I have been trying to solve this one for a while without success. I receive pricelists from distributors that I convert to PDox9 tables, then perform searches for Product IDs to modify my internal table. All works perfectly well, except for the times when the Alpha field I am searching contains a parenthesis " ( or ) " . In this case the search is unable to match the record. I do not see this problem with fields containing  # /.  - = etc. I am using advancedWildcardsInLocate(Yes) for the session.

Any way around this? I am unable to change the fields as they are manufacturer product IDs.

Thanks in advance,

Grant

Please ignore. I ended up solving it after adding the advancedWildcardsInLocate(Yes), and then changing from locatePattern() to simply locate(). I probably made the change prior for some reason haha.

Grant