Harish CS wrote: > 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.
Read up on collation on sqlite.org > 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 -- Puneet Kishor http://punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Fellow http://creativecommons.org/about/people/fellows#puneetkishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu --------------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science =========================================================================== _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users