UPDATE and REPLACE part of a string

by

You don’t need wildcards in the REPLACE – it just finds the string you enter for the second argument, so the following should work:

UPDATE dbo.xxx
SET Value = REPLACE(Value, '123', '')
WHERE ID <=4

If the column to replace is type text or ntext you need to cast it to nvarchar

UPDATE dbo.xxx
SET Value = REPLACE(CAST(Value as nVarchar(4000)), '123', '')
WHERE ID <=4

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. sql server 2008 management studio not checking the syntax of my query
  3. Split function equivalent in T-SQL?
  4. Is the NOLOCK (Sql Server hint) bad practice?
  5. How to create a table from select query result in SQL Server 2008 [duplicate]
  6. Querying data by joining two tables in two database on different servers
  7. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  8. Where value in column containing comma delimited values
  9. How to find all connected subgraphs of an undirected graph
  10. Parse comma-separated string to make IN List of strings in the Where clause
  11. How to use table variable in a dynamic sql statement?
  12. OPTION (RECOMPILE) is Always Faster; Why?
  13. Create Trigger to log SQL that affected table?
  14. Rename column SQL Server 2008
  15. Compare DATETIME and DATE ignoring time portion
  16. Split function in SQL Server 2008
  17. Remove numbers from string sql server
  18. Can I set ignore_dup_key on for a primary key?
  19. Selecting first row per group
  20. How do I edit a table in order to enable CASCADE DELETE?
  21. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  22. SQL Server SELECT LAST N Rows
  23. Converting Select results into Insert script – SQL Server
  24. How to retrieve field names from temporary table (SQL Server 2008)
  25. When using GETDATE() in many places, is it better to use a variable?
  26. Executing SQL Server Agent Job from a stored procedure and returning job result
  27. Select SQL Server database size
  28. Backup a single table with its data from a database in sql server 2008
  29. COALESCE Function in TSQL
  30. Try_Convert for SQL Server 2008 R2

Leave a Comment