Yeah, I find myself feeling that way often....usually after about 12 hours of staring at the monitor...
Douglas Brown Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Jeff Beer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 10, 2002 12:50 PM Subject: RE: search/replace in SQL server > 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> > > > > > > > > ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
