>If a field is SQL Server reserved word, you need to use []. You can use it for regular fields as well. In other words, you can use it every time.

Thanks. My issue actually turned out to be because I'm using TEXT field type. Had to cast it do it like

set description=replace(cast(description as varchar(max)),'\',' \')