Re: Sorting UK Postcodes (WAS Sorting Results)

Damien -- What about: select substring(code, 1, 1) as letter, substring(code, 2, 2) + 0 as number from epost order by 2 +++ | letter | number | +++ | E | 1 | | E | 2 | | E | 3 | | E | 4 | | E | 10 | | E

re: mysql client question

If you're on a unix-like machine, you might be able to just type edit at the mysql> prompt, which might take you to a vi session, much better for editing complex sql commands. When you want to execute the command, in vi just do ZZ, which will take you back out to mysql client. Type go or \G t