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> > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists