Sorting by number is not important, it was more a general question about sequences of "variousnameXXX" and how to order them correctly with a simple query. Splitting in 2 fields seems the only way then. For the postcode it's just to provide the user with an easy lookup table, but it's not *that* important since the way it's ordered now is the same as many (if not all) file systems do. > If sorting by number is important, then split them on input and > store them > in two separate files. But I don't really know why you'd want to > sort them > numerically anyway - UK postcodes aren't sequential in operation: > E1 is not > necessarily adjacent to E2 on the map. So having a sequence of E1,E10,E2, > etc is no less applicable than E1,E2,E10 would be.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php