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]
