I have database fields 1234567891.001;
I want to sort on first 10 digits descending; (last date first)
then ascending on the last 3 digit (page numbers)
the statement below gives the right answer,
but is this how to do it?
SELECT substr(imgname,1,10) AS name, substring(imgname,12,3) AS pg FROM
fax GROUP BY imgname, pg ORDER BY name DESC, pg ASC;
TIA
rfjones