How do I do a simple ‘Find and Replace” in MsSQL?

January 22, 2023 by Tarik

The following query replace each and every a character with a b character.

UPDATE 
    YourTable
SET 
    Column1 = REPLACE(Column1,'a','b')
WHERE 
    Column1 LIKE '%a%'

This will not work on SQL server 2003.