> I tried the follwing with no results: > > select areacode from stdcodes where '01865323260' like areacode || '%'
Don't know what to tell you. Here's an actual query: sqlite> select id from entities where 'tmkxyz' like id || '%'; id ---------- tmk Looks analogous to what you're trying to do. What version of SQLite are you using? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]