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 -
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&
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' );
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
4 matches
Mail list logo