Thanks Kurt, The GUI I was using to run the query seems to be using an old version of the SQLite DLL. I haved tried another one and the query has got me closer to what I want. The problem I now have is that I am getting too many results. ie. SELECT areacode FROM stdcodes WHERE '0018764582' LIKE areacode || '%';
results: 001 USA 001876 Jamaica As you can see the second result is the correct one, is there a way I can narrow down the result to the nearest fit? > > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]