I tried googling this but every post I find, the OP is using insert or join. Well I am not. I am trying to replace a string in a column,
Name = Service1
begin tran UPDATE [User] SET Details WHERE Name=Service1 SELECT replace('ACC_STATUS:Deactivated', 'Deactivated', 'Activated') rollback
When running this I get
Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'WHERE'.