Harish CS <cshar...@gmail.com> wrote: > Collation is okay for case insensitivity but since here we have digits and > special chars I think it may not be helpful. Plz correct me if I am wrong.
You can implement a custom collation that defines any order of your choice. See http://www.sqlite.org/c3ref/create_collation.html -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users