>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
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.