Not sure about RegEx, but if it's always the same HTML tag, you can use MySQL's REPLACE() function. Jeffrey -- Cheers. Jeffrey Barke jeffrey.barke at theMechanism.com Lead Developer, US theMechanism - New York City 440 9th Avenue, 8th Floor New York, NY 10001-1631 t: +1 212.404.3150 c: +1 917.941.1232 f: +1 212.404.3228 http://www.theMechanism.com Subscribe to theMechcast, our monthly Podcast: http://feeds.feedburner.com/theMechcast theMechanism - London 3rd Floor 405 The Strand London E14 9FW United Kingdom t: +44 (0)20 7240 4964 f: +44 (0)20 7240 2262 -- The information contained in this Electronic mail message is attorney privileged and confidential information intended only for the use of the individual or entity named above. Such information also is intended to be privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone. Blah, blah, blah... -- On Dec 12, 2007, at 2:45 PM, Chris Dempsey wrote: > Hi, > > > > Is it possible to run an SQL SELECT statement and apply a regular > expression > to a field that will manipulate the data returned at the time of > running the > SELECT? > > > > I appreciate that I may be phrasing my question incorrectly but > what I want > to achieve is to pull a list of product names from the database and > use > RegEx to strip a specific HTML tag from each record. > > > > I know that I could strip the tags out at the time of looping > through the > recordset and writing the product names to screen but this is not > feasible > in this case [I need to tweak a pre-built shopping cart but don't > want to go > through thousands of lines of code if it can be done on the SLECT > statement]. > > > > I've asked Google but am not finding anything that tells me if this > is even > possible, never mind examples of how it might be done. > > > > Thanks, > > > > Chris. > > > > Ps. The bad news is it's Access not MS SQL or MySQL. > > > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt !