Are AB3, AB4, AB10, etc. hexadecimal values? If so, use a hex to integer conversion and sort. If they are 'just' strings then you'll have to do something else because those aren't 'numbers' so you can ...

Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...