UPDATE Auths SET  P1=replace(replace(replace(replace(LTRIM(RTRIM(REPLACE(REPLACE(P1, CHAR(13), ''), CHAR(10), ''))),'\t',''),'\n',''), '  ', ''),'\r','')
where P1 like '%\t%' or P1 like '%\r%' or P1 like '%\n%' or P1 like '%  %'