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