set Part = LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(Part, CHAR(10), CHAR(32)),CHAR(13), CHAR(32)),CHAR(160), CHAR(32)),CHAR(9),CHAR(32))))
My data got contaminated with some kind of invisible character it seems. I was able to replace the hidden character with the above in sql.