T-SQL removing CHAR(10) and CHAR(13)

--SELECT REPLACE(REPLACE(REPLACE(MyField, CHAR(10), ''), CHAR(13), ''), CHAR(9), '')

declare @NewLine char(2)

set @NewLine=char(13)+char(10)

update tblMetrics

     set MetricThreshold = Replace(MetricThreshold , @NewLine,'')

WHERE MetricThreshold like '%' +@NewLine +'%'

     AND MetricID = 999999