T-SQL string replace in Update

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

User · 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

User · Answer

update YourTable     set YourColumn   replace YourColumn    domain2     domain1       where charindex   domain2   YourColumn   lt  gt  0

User · Answer

If anyone cares  for NTEXT  use the following format   SELECT CAST REPLACE CAST  ColumnValue  AS NVARCHAR MAX    find   replace   AS NTEXT       FROM  DataTable

[string] T-SQL string replace in Update

Examples related to string

Examples related to tsql

Examples related to replace