Re: [sqlite] Best Match Query

re, reproduction, or dissemination) > by persons other than the intended recipient(s) is prohibited. If you receive > this e-mail in error, please notify the sender by phone or email immediately > and delete it! > **********

Re: [sqlite] Best Match Query

tify the sender by phone or email immediately and delete it! * - Original Message - From: Simon Davies <[EMAIL PROTECTED]> Date: Monday, August 6, 2007 8:12 pm Subject: Re: [sqlite] Best Match Q

Re: [sqlite] Best Match Query

Hi Ragha, C:\Joinerysoft\JMS\TestArea>sqlite3 tst.db SQLite version 3.4.0 Enter ".help" for instructions sqlite> sqlite> create table tst( c1 integer, c2 test ); sqlite> insert into tst values( 1, '44' ); sqlite> insert into tst values( 2, '442' ); sqlite> insert into tst values( 3, '4454' ); sql

[sqlite] Best Match Query

Hi, How to form the SQL query(in SQLite) for the following problem below table: 44 442 4454 Input String: 4429845 Expected output from SQL query: 442 regards ragha ** This email and its attachments conta