On 5 Aug 2009, at 8:43pm, Kalyani Phadke wrote: > My query "select Name from ABCD order by Name" The expected result > aaa > Test > test > > but I am getting > Test > aaa > test
How are you getting these results from ? Are you typing your SELECT command into the command-line tool or using another program to execute it ? Are you creating your database from scratch each time you test this sequence of commands or are you using an existing database file ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users