Finding a line break in a text string in a SQL table?

SELECT foo FROM test WHERE foo LIKE '%' + CHAR(10) + '%'

Edit: to find all various types of line endings you should probably just check both:

SELECT foo FROM test WHERE foo LIKE '%' + CHAR(10) + '%'
                        OR foo LIKE '%' + CHAR(13) + '%'