Hi, We have a problem with a sql query. In a table, a column called "name" contains character data that may include alpha, numeric and special characters. It is required to sort in such a way that names starting with alpha characters are listed first, then numerals and finally special characters. For example, the column contains data: [Bhaskar, 5th user, anand, ##, Anand, bhaskar ]. When lsited, it should appear as [Anand, anand, Bhaskar, bhaskar, 5th user, ##]. The query "select name from mytable order by name asc;" lists data in this order [##, 5th user, Anand, Bhaskar, anand, bhaskar], which is not correct. Any ideas on this? All thoughts are welcome. -Thanks Harish -- View this message in context: http://old.nabble.com/SQL-query-on-sort-order-tp30455015p30455015.html Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
