REPLACE

SQL -Find and replace text in string

The following T-SQL for Microsoft  SQL Server shows how to find and replace text in a string. In this example we'll change "PO Box" to "P.O. Box". The REPLACE  function will search for…