Robert martin wrote:

> With Standard firebird (no UDFs) is it possible to get a list of results
> ordered numerically but ignoring negative signs.

In Firebird 1 you could use:

select Amount, Amount
from MyTable
where Amount >= 0

union all

select Amount, -Amount
from MyTable
where Amount < 0

order by 2

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org