Viewing 2 posts - 1 through 3 (of 3 total)
Well, found the problem. It wasn't with NewLines, it was with sizing the binary data type. It just happened to be that NewLines occured at the max default length of...
March 15, 2007 at 8:46 am
#695241
I have tried just about every version of replace I could think of including:
REPLACE(CAST(TABLE.FIELD AS binary), '0D0A', '2020')
REPLACE(REPLACE(CAST(CAST(TABLE.FIELD AS binary) AS varchar), CHAR(13), ' '),...
March 14, 2007 at 5:44 pm
#695112