Re: [sqlite] Matching telephone strings

2004-04-10 Thread Kurt Welgehausen
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

Re: [sqlite] Matching telephone strings

2004-04-10 Thread Lloyd thomas
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