Is this what you desire to do?

CREATE TABLE #T(Id INT,SomeText VARCHAR(300))

INSERT INTO #T

SELECT 9,'This is 1Tab' UNION ALL

SELECT 13, 'This is a

line feed' UNION ALL

SELECT 1000,'This has a taband a line

feed' --edited ,, us a tab, carriage return and a line feed

----single tab character in between % in first LIKE and a carriage return and Line feed in second LIKE

SELECT ID FROM #T WHERE SomeText LIKE '%%' OR SomeText LIKE '%

%'

Displaying the results as text using SSMS

Id SomeText

----------- -------------------

9 This is 1Tab

13 This is a

line feed

1000 This has a taband a line

feed

Edited to correct tab, carriage return and line feed useage