SQL Serverで改行コードを発見・置換

SELECT * FROM table
WHERE name LIKE '%' + CHAR(13) + '%';
SELECT * FROM table 
WHERE name LIKE '%' + CHAR(13) + CHAR(10) + '%';
SELECT * FROM table 
WHERE name LIKE '%' + NCHAR(13) + NCHAR(10) + '%'; 
UPDATE table SET 
name = REPLACE(name, CHAR(13), ' ');
UPDATE table SET 
name = REPLACE(name, CHAR(13) + CHAR(10), ' ');
UPDATE table SET 
name = REPLACE(name, NCHAR(13) + NCHAR(10), ' ');