Using the LIKE qualifier instead of = will result in case insensitive matches.
Shawn M. Downey MPR Associates 10 Maxwell Drive, Suite 204 Clifton Park, NY 12065 518-371-3983 x113 (work) 860-508-5015 (cell) -----Original Message----- From: manoj marathayil [mailto:[EMAIL PROTECTED] Sent: 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 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), type integer, primary key ( dbname, object_name, arglist ) ); then i issued a query like this; select * from ((select distinct(tablename), type from objects where dbname = 't_test' union select object_name as 'a', type from sp_objects where dbname = 't_test') as t) order by 2 asc; this is working as i expected but if i use "order by 1 asc" its not working, how can i solve this, thanks in adv... --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. T h a n k s & R e g a r d s , Manoj M | Webyog | Bangalore | Voice: 91 9886171984, 91 80 51216434(off) "A winner is not one who never fails, but one who never quits!" --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time.