Using REPLACE

Using REPLACE.

1. Sql Server
2. String manipulation
3. Beginner
4. Vaknin Sammy

Last updated: 13 October 2016

Warning: Review and test in a non-production environment before running.

SELECT REPLACE('This is my string', 'is', 'XX') 

-- Returns 'ThXX XX my string'.