Thanks. Lloyd ----- Original Message ----- From: "Kurt Welgehausen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 4:58 PM Subject: Re: [sqlite] Matching telephone strings
> > ..., but is it correct? > > No, very dangerous. You're depending on the values of band > and destination just happening to be correct in this > implementation. > > select areacode, band, destination from stdcodes > where areacode = (select max(areacode) from stdcodes > where '001212' like areacode || '%') > > --------------------------------------------------------------------- > 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]