>Right, but what again is the problem? You seems to be answering yourself and not me.
The initial syntax was targeting a char field and was causing the problem. As Subject_E is a char field, the replace can be used as is without a cast. This was a bad cut & paste and it led to confusion. The original code was put back and still works. Body_E is the Varchar(MAX) field and that one is working with the usage of cast.
Thanks