Harish, >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, >##].
I just mailed you an extension for SQLite offering the collation you need. Hope it will fit your bill. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users