[sqlite] Any field LIKE?

[Tomas Franz�n]

Hi,
I have finally finished the SQLite external for SuperCard, which means 
another programming environment has access to SQLite! :-)

Is there a way to build a SELECT statement that selects a row if any of 
the columns is LIKE something?
Something like: SELECT * FROM people WHERE * LIKE "a%";
Or do I have to make a LIKE for every column?

Thanks.
Tomas Franz�n
Lighthead Software
http://www.lightheadsw.com/