How can I check if an SQL result contains a newline character?

Question

I stored (or think I stored) some text from a textbox that is effectively 'lol\ncats'

In SQL management studio it comes up in the description has 'lol cats'

How can I check if the \n is there or not?

Answer 1

SELECT *
FROM your_table
WHERE your_column LIKE '%' + CHAR(10) + '%'

Answer 2

SELECT * 
FROM Table 
WHERE PATINDEX('%' + CHAR(13) + CHAR(10) + '%', Column) > 0

Answer 3

using char(13) for '\r' and char(10) for '\n'

SELECT *
FROM your_table
WHERE your_column LIKE '%' + CHAR(10) + '%'

or

SELECT *
FROM your_table
WHERE your_column LIKE '%' + CHAR(13) + CHAR(10) + '%'