Jun 28, 2013 · I've got a table with two columns, ID and Value. I want to change a part of some strings in the second column. Example of Table: ID Value ...

Replace function in SQL Asked 7 years, 1 month ago Modified 7 years, 1 month ago Viewed 19k times

May 2, 2009 · 414 I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to …

Apr 22, 2014 · I am trying to convert a varchar field to a number, however, there is a set of common characters inside that field that need to be removed in order for me to successfully …

However, ordinarily you'd replace ' with '' and this will make SQL Server happy when querying the database. The trick with any of the built-in SQL functions (like replace) is that they too require …

Aug 30, 2016 · If you want to replace multiple words or characters from a string with a blank string (i.e. wanted to remove characters), use regexp_replace() instead of multiple replace() clauses.

Oct 20, 2016 · I have a table of names and addresses, which includes a postcode column. I want to strip the spaces from the postcodes and select any that match a particular pattern. I'm trying …

I'm using SQL Server Express 2012. I'm having trouble removing the unicode character U+02CC (Decimal : 716) in the grid results. The original text is 'λeˌβár'. I tried it like this, it doesn't work:

Apr 13, 2013 · using if statement how to replace values Asked 12 years, 8 months ago Modified 10 years, 6 months ago Viewed 34k times

I have the REPLACE(Name, ' ','') function to remove spaces and the UPPER() function to capitalize the name. Is there a more efficient fast way maybe by terms of regex to replace …