>I'm having trouble sorting the following data: > >point_number - VARCHAR(10)
I've developped an SQLite extension including a very similar collation: it sorts the (integral) prefix first and, in case of a draw, orders based on the Unicode suffix. It currently doesn't cope with floating-point prefixes but can surely be adapted easily to do so. It's only a small part of a larger code for facilitating scalar handling of Unicode text, but you can trim it down to only the part you need. If you're interessed in the source, just drop me a mail. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
