Re: [sqlite] Best Match Query

2007-08-06 Thread Jim Dodgen
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! > *** ** > > - Original Message -

Re: [sqlite] Best Match Query

2007-08-06 Thread RaghavendraK 70574
it! * - Original Message - From: Simon Davies <[EMAIL PROTECTED]> Date: Monday, August 6, 2007 8:12 pm Subject: Re: [sqlite] Best Match Query > Hi Ragha, > > C:\Joinerysoft\JMS\TestArea&

Re: [sqlite] Best Match Query

2007-08-06 Thread Simon Davies
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' );

[sqlite] Best Match Query

2007-08-06 Thread RaghavendraK 70574
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