>I have the following SQL:
>
>

SELECT pk_contract_id, cDesc  ;
>	FROM Contract ;
>	WHERE UPPER(Contract.cDesc) LIKE 'A%' ;
>	ORDER BY cDesc

>I need the result sorted by upper(cDesc). I can't do ORDER BY upper(cDesc) I found out :(
>
>I had two other ideas.
>1) Add a 3rd column upper(cSort) as cDesc then ORDER BY cSort
>2) index the resulting cursor after the select.
>
>Are those the only ways to accomplish it? I was hoping I could do it all in one shot with the sql.

Maybe not the best way, but it works:

SELECT pk_contract_id, cDesc, UPPER( cDesc ) AS cDescUpper ;
FROM Contract ;
WHERE UPPER(Contract.cDesc) LIKE 'A%' ;
ORDER BY 3