We are still trying to optimise a huge data export. we need to sort the data before exporting, by two fields:
logdate (date) docno (char(4))
This works, but due to docno being char, not quite right:
select * from docinfo into cursor working ;
order by logdate ASC, docno ASC

Trying
order by logdate, VAL(docno)
returns SQL: colum logdate is not found

for fun (or is it frustration) we tried just VAL(docno) and got:
column not found.

Both fields are indexes.