Q:

Correct grammar with LIKE condition in SQLite

With SQLite I can:
select my_column from my_table where substr(word,1,1) like '%I%';

so I'll have all the string results whose first character is I. But now I want to have results whose first character is I and F and J. I have tried:
select my_column from my_table where substr(word,1,1) like '%I%'&'%F%'&'%J%';

but that doesn't work.
What grammar should I use to find results with those first letters?

A:

Here's the right answer: SELECT mycolumn FROM mytable WHERE upper(substr(word,1,1)) IN ('I', 'F', 'J');

