Replace or Update partial field

• tammy scolari

  Valued Member

  Points: 66

  More actions

  January 3, 2007 at 10:31 am

  #175437

  I need to replace or update email addresses.  The address is in one field. 

  Example:  emailname@emailaddress.net

  Many (not all) of the emailaddress.net need to be replaced with a new email address. The email name needs to remain.

  This is what I tried but I have something wrong.

  SELECT = replace('emailaddress.net', 'emailaddress.net', '%@newaddress.net')

  Then I tried this -

  UPDATE dbo.tablename

  SET email_address = %'@emailaddress.net'

  WHERE email_address LIKE '%@newaddress.net'

  I think I changed everyone's name to % with one of these.  I at least am working on a copy of the database - and I am skilled and restoring my copy!!

  Any help would be great!

  ---

  Kindest Regards,

  Tammy
  

• Dinakar Nethi-176633

  SSCarpal Tunnel

  Points: 4689

  More actions

  January 3, 2007 at 12:38 pm

  #681025

  Update dbo.tablename

  SET email_address = Replace(email_address, '@emailaddress.net', '@newemailaddress.net')

  Syntax:

  REPLACE(string, , )

  Before you do an UPDATE, you can do a SELECT

  SELECT email_address , Replace(email_address, '@emailaddress.net', '@newemailaddress.net')

  FROM dbo.TableName

  to see which rows get updated.

  ******************
  Dinakar Nethi
  Life is short. Enjoy it.
  ******************

• tammy scolari

  Valued Member

  Points: 66

  More actions

  January 3, 2007 at 12:57 pm

  #681031

  SELECT email_address , Replace(email_address, '@emailaddress.net', '@newemailaddress.net')

  FROM dbo.TableName

   

  This delivers all email addresses not just the email addresses ending in emailaddress.net.  20,000 emails vs 2,000.  I messed around with it a bit and I am still doing something wrong.

  More help needed - please.

  ---

  Kindest Regards,

  Tammy
  

• tammy scolari

  Valued Member

  Points: 66

  More actions

  January 3, 2007 at 1:11 pm

  #681038

  SET email_address = Replace(email_address, 'emailaddress.net', 'newemailaddress.net')

  Gives this errorLine 1: Incorrect syntax near '='.

  ---

  Kindest Regards,

  Tammy
  

• tammy scolari

  Valued Member

  Points: 66

  More actions

  January 3, 2007 at 1:38 pm

  #681043

  IT WORKED!!

  update tel_tldiremp

  SET email_address = Replace(email_address, 'emailaddress.net', 'newemailaddress.net')

   

  IT WORKED!!!

  THANK YOU!!  IT WORKED!

  ---

  Kindest Regards,

  Tammy