RE: [sqlite] sql problem

2006-02-09 Thread Downey, Shawn
: Thursday, February 09, 2006 1:25 AM To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] sql problem i am able to get the result but the problem is it is case sensitive, i want a case insensitive manoj marathayil <[EMAIL PROTECTED]> wrote: i have two tables like this; CREATE

Re: [sqlite] sql problem

2006-02-08 Thread manoj marathayil
i am able to get the result but the problem is it is case sensitive, i want a case insensitive manoj marathayil <[EMAIL PROTECTED]> wrote: i have two tables like this; CREATE TABLE sp_objects ( dbname varchar(256), object_name varchar (256), arglist varchar(256), type integer, primary key ( dbn

[sqlite] sql problem

2006-02-08 Thread manoj marathayil
i have two tables like this; CREATE TABLE sp_objects ( dbname varchar(256), object_name varchar (256), arglist varchar(256), type integer, primary key ( dbname, object_name, arglist ) ); CREATE TABLE sp_objects ( dbname varchar(256), object_name varchar (256), arglist varchar(256