>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

It works properly for a test case I ran placing the negative numbers at the top, but the syntax should be:

sele val(field) as xyz from mytable order by xyz

Bill