ouch! I don't feel stupid now.. no - really.. That's what I get for overthinking a simple problem..
-----Original Message----- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 3:26 PM To: CF-Talk Subject: Re: search/replace in SQL server UPDATE your_table set email = REPLACE(email,'@home.com','@attbi.com') Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Jeff Beer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 11:37 AM Subject: OT: search/replace in SQL server > Can anyone toss me the SQL to replace the domain in an e-mail address > in SQL? > > I need to clean up someone's CRM database and change "[EMAIL PROTECTED]" to > "[EMAIL PROTECTED]" - I can't seem to wrap my brain around it.. > > TIA, > > Jeff Beer > Director of Application Development > Digital Stormfront, Inc > http://www.digitalstormfront.com <http://www.digitalstormfront.com> > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
