>>>>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.
Glad I could help out.
Chris McCandless
Red Sky Software