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.