I have a table which contains a text column called 'Note'.
This column contains null values and some string values. The update query below was run on the table when it shouldn't have been.
update tblExample set Note = Note + ' USD Temp influx'
So the rows with null's in them haven't changed but the other rows have.
I want to remove this text from the field and leave any other text already in there remaining. What is the best way to do this?
Is it something like below but in an update query? Not sure how this should be written?
select replace(Note, ' USD Temp influx', '') from tblExample?
sorry should have said the column is a nvarchar type