On Thu, Feb 4, 2010 at 11:23 PM, Paul McNett <[email protected]> wrote: > > I can't remember: does VFP's SELECT-SQL allow for searching using regular > expressions? Because your problem just calls for a regex solution. > > Paul
I don't believe it supports RegEx, but it does support wildcards, so SELECT * FROM MyTable WHERE MyPartID LIKE "12A456789-%123%" will return records with zero _or_more_ characters in the % positions; you can then use VFP string parsing to determine if they match the rest of your requirements. In other words, you'd need to filter out of the result set the ID like 12A456789-012345 if that didn't meet your requirements. But it narrows down a half million records to just a few. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
