>>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)),'\',' \')

Should have posted the error then :) Yes, it's better to forget about text type in SQL Server 2005 and up.