Build SQL Query With multiline Condition

Question

I need to build query in SQL to get rows the have text like that 'TEXT1\r\nTEXT2'.

For example something like that:

SELECT * 
from Table1 
where Name LIKE '%TEXT1\r\nTEXT2%'

Answer 1

SELECT * FROM Table1 WHERE Name LIKE '%TEXT1' + CHAR(13) + CHAR(10) + 'TEXT2%';

http://msdn.microsoft.com/en-us/library/ms187323.aspx