>>If Body_E is the varchar(max) column, you don't need a CAST.
>
>It is Text.
>
>>If it's Text column, it needs a cast (one way only). In both cases the replace will be case-insensitive unless the column is defined with case sensitive collation.
>
>Yes, that works.
Ok, good. In other words, there was no problem in the first place :)
If it's not broken, fix it until it is.
My Blog