Hey - -- - MySQL is the engine. I'm trying to do a SELECT where it retrieves only the alpha values in the field, to wit:
in_field => result set abc123 abc wzyt4 wzyt asdf2345 asdf MySQL's replace function needs an exact match. There is a REGEXP function, but it only seems to return a 1 or 0 if there is a matching pattern in the field or not. Anyone know if this is possible? Ken _______________________________________________ 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.

