> 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
I tried the follwing with no results:
select areacode from stdcodes where '01865323260' like areacode || '%'
if I do:
select areacode from stdcodes where '01865' like areacode
that works OK, but that is more or less the same as what I do already.
Am I missing something?
- Original Message
> Is there any faster way I can compare these telephone numbers within sqlite?
How about something like
select areacode from stdcodes
where $telno like areacode || '%'
Regards
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
I am using delphi to campare telephone numbers against a table of telephone number
area codes. These arecodes can be upto ten digits, so using a for loop, I am comparing
the the first ten digits of the number. If there are no matches I then will delete one
digit from the right of the telephone n
4 matches
Mail list logo