Using SQL Server Management Studio and I am trying to replace a certain string with another.
The Table - tbl_customer
The Column - Address
For the sake of testing looking for X and replacing it with Y - Here is my current effort.
update tbl_customer SELECT REPLACE(Address, 'X', 'Y')
This seems to find the instance and displays the Y however, it does not update the table?.....