I have an SQL statement:

sele val(field) as xyz from table sort by xyz

It looks like the sort is happening before the val conversion because negative numbers aren't at the top. Is there anything I can do in the SQL statement to make this work correctly?

TIA,

E.R. Gilmore