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 ...
I need to order my hordes of rows by a column that contains alphabetical and numerical data, but I need the data to be ordered numerically rather than alphabetically, ie... Are AB3, AB4, AB10, etc.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results