>>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)),'\',' \')
TEXT type in SQL Server 2005!!!!!!!!!!!!!!!
Grrrr,
Change it immediately to n/varchar(max)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.