T-Sql String Replace in Update

Name: T-Sql String Replace in Update
Uploaded: 2026-10-04T12:09:51+00:00
Duration: 8 min 15 s
Description: I Need to Update the Values of a Column, with a Substring Replace Being Done on the Existing Values. Example: Data Contains Abc@Domain1, Pqr@Domain2 Etc. I...

Question

I need to update the values of a column, with a substring replace being done on the existing values.

Example:

Data contains abc@domain1, pqr@domain2 etc.

I need to update the values such that @domain2 is replaced with @domain1.

Accepted Answer

The syntax for REPLACE:

REPLACE (string_expression,string_pattern,string_replacement)

So that the SQL you need should be:

UPDATE [DataTable] SET [ColumnValue] = REPLACE([ColumnValue], 'domain2', 'domain1')

Answer 2

If anyone cares, for NTEXT, use the following format:

SELECT CAST(REPLACE(CAST([ColumnValue] AS NVARCHAR(MAX)),'find','replace') AS NTEXT) 
    FROM [DataTable]

Answer 3

update YourTable
    set YourColumn = replace(YourColumn, '@domain2', '@domain1')
    where charindex('@domain2', YourColumn) <> 0

T-Sql String Replace in Update

3 Answers

Must Read

Your Answer

Chloe Bennett

T-Sql String Replace in Update

3 Answers

Must Read

Your Answer

Sign up or log in

Post as a guest

Chloe Bennett