On Wed, 2007-08-29 at 16:43 +0800, RaghavendraK 70574 wrote:
> Hi,
>
> create table test (t text);
>
> insert into test values ('9');
> insert into test values ('98');
> insert into test values ('986');
> insert into test values ('9867');
>
> select * from test where '98555' like t || '%' order by t desc limit 1;
There are no SQL variables to bind to in that statement. Syntax
for SQL variables is here:
http://www.sqlite.org/lang_expr.html
Dan.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
