SQL WHERE LIKE with tab

Question

Seems like such a simple thing. I need to specify a WHERE criteria with the LIKE operator and include a tab in the expression.

SELECT * FROM table WHERE field LIKE '%Run1[TAB]%';

I've tried \t, \\t, %t and the char operator.

I am working in Sqlite.

Thanks.

Answer 1

try

CAST(X'09' AS TEXT)

for the tab character

Answer 2

I'm using DB2, but maybe this solution is something you can use on Sqlite also.

Try using the chr function. I think in ASCII the tab character has value 8. In DB2 the following works

SELECT * FROM table WHERE field LIKE '%' || chr(8) || '%'