Find Special/Escape Characters in Sqlite

Find TAB

SELECT * FROM table WHERE column LIKE '%' || X'09' || '%';
SELECT * FROM table WHERE column LIKE '%' || CHAR(9) || '%';

Find CR LF

SELECT * FROM table WHERE column LIKE '%' || CHAR(13) || CHAR(10) || '%';