• I found the exact syntax in a another unrelated sqlservercentral post once I figured out what the problem was.

    replace(replace(table1.col1, char(13), ''), char(10), '') AS 'updated_field'