>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
Right, but I need cDesc's case to remain as is. That's why I was thinking of adding a 3rd column just for the order by clause. Thanks anyway.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
