Detect line break in SQL query

To detect a line break within a SQL query, the below script will replace line breaks with a tilde (~).

SELECT REPLACE(Notes, CHAR(10), '~')
FROM Table


Other characters you may want to replace:
Tab -> char(9)
Line feed -> char(10)
Carriage return -> char(13)