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 ----- From: "Kurt Welgehausen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 12:20 AM Subject: Re: [sqlite] Matching telephone strings > > 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 additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]