>>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 Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown