Thanks All (Ted, Ricardo, Richard & Stephen) Functions in SQL return unexpected results (sometimes, which is too much), CHRTRAN() would take out ALPHA characters in the part number base (which is essential). RegExp are not supported in SQL (VFP anyway). I have never used wild cards in SQL but that wouldn't take care of an issue like:
12A456789-123 = 12A456789-%12%" Or 12A456789-1234 = 12A456789-%123%" the UNION/ISALPHA looks like my winner. This is getting to be a habit Ted ... you saving my a$$. Again, many thanks to all. It never fails that when I run into a problem THE board pulls me through. I try not to be a pain but every now and then I need someone to pull my A$$ out of the wringer!! THANKS!!! Best, Francis I. Coppage, Jr. -- "Two things are infinite: the universe and human stupidity; and I'm not sure about the universe." ... Albert Einstein _______________________________________________ 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/02d301caa6b0$6fc1fec0$4f45fc...@net ** 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.
