Hi,

This query works well:

Select SubString (FIL1.RECEIPT FROM 1 FOR 7) as RECEIPT
From MYTABLE FIL1
Order by RECEIPT

But if I use the alias of the table in the Order by, it does not work:

Select SubString (FIL1.RECEIPT FROM 1 FOR 7) as RECEIPT
From MYTABLE FIL1
Order by FIL1.RECEIPT

Any idea?

Thanks,

<< But if I use the alias of the table in the Order by, it does not work: >>

DBISAM only allows column names in ORDER BY, GROUP BY, and HAVING clauses that are found in the SELECT column expressions, so you would have to write it like this:

Select FIL1.RECEIPT, SubString (FIL1.RECEIPT FROM 1 FOR 7) as SUBRECEIPT
From MYTABLE FIL1
Order by FIL1.RECEIPT

ElevateDB, on the other hand, *does* allow for your original query.

Tim Young
Elevate Software
www.elevatesoft.com