you really could find out which rows / data has carriage returns and fix the source data.. instead of just put a bandaid on it.
UPDATE table Set Field = Replace(Replace(Field, CHAR(10), ' '), CHAR(13), ' ') WHERE Field like '%' + CHAR(10) + '%' or Field like '%' + CHAR(13) + '%'