>>>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.
>
>
>What he has keeps cdesc's case as is... you will simply have another column in your result named cdescupper that is cdesc UPPERed.
>
>
>HTH
Wayne- Right, I read through it to fast. Thanks for pointing it out.
Chris- Thanks for the idea.
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!