Execute SQL Control Flow removing character
I am trying to execute a simple SQL Upddate Statement
update oraclecontact
set Technical_Questions=LTRIM(RTRIM(REPLACE(Technical_Questions,'{and evil square here}',char(13)+char(10))))
The purpose of this is to remove the evil character which is SQUARE that I cannot paste in here for some reason.
I can run the sql which runs fine in Mangment Studio but when I run it as a Execute SQL Control flow it replaces the "SQUARE" with a carriage return and removes the square therefore my update statement does not replace the "SQUARE".
The entive point of this update statement is to replace the squares in the date with carriage returns to it shows formatted properly.

