Make that order by xyz

>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