>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.