Help with creating a data base query to remove email address's

stasnek

A while back some folks helped me create a query to take out my old admin's email address and insert mine.

They mentions setting up a distribution list and I have completed that and it is working.

The problem I have now is how do I remove email address's total from the data base.

We have changed wan/lan vendors. They all have @att.com email address's.

I modified the old update email with this.

I was wondering if someone could tell me if this would work and if not suggest a way to do it.

NEW

update ActionDefinitions

set Target = remove (

    CAST(Target as nvarchar(4000)),

    ' *@att.com', --string you are searching for - to be removed

    )

OLD

update ActionDefinitions

set Target = replace (

    CAST(Target as nvarchar(4000)),

    'chris_stasnek@campbellsoup.com', --string you are searching for - to be replaced

    'Solarwinds_notification@campbellsoup.com'  --string to replace found expression

    )

LadaVarga

If the old query working you can use same for removing adresess but you have to check every email address because SQL doesn't support regexp.

OLD

update ActionDefinitions

set Target = replace (

    CAST(Target as nvarchar(4000)),

  'name@att.com',   '' )

Of course u can remove all "*att.com" by one query but it will be remove whole row and I think that what you don't need.

Here is generic query for substring replacement.

UPDATE Table_Name

SET Column_Name = REPLACE(Column_Name, 'Text_To_Be_Replaced', 'New_Text')

WHERE Column_Name LIKE '%Text_To_Be_Replaced%'