Have you given any thought to adding a GREP option to the like-ops? I have a situation where I'd like to select records based on the value of the 3rd word in a particular column. Unless there's a way to do it with LIKE or GLOB?
You can use the sqlite3_create_function() API to provide your own implementation of LIKE and/or GLOB that does whatever you want.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565