OPNQRYF Again!!

[Guest.Visitor]

I was wondering if there is a technique for doing mutiple functions with a single qryslt? What I need is a way of Converting a Physical file with a mixed Case description(30 Char). Then I need to do a wilcard scan on The %xlate function. Example: I am passing &DSDESC Value(Peach) In my file I have PEACH And Peach, and peach in my Physical file. I am doing my wilcard and it is working nicely, thanks to Mr. Holt After I pass Peach,I *tcat an * on the end of Peach value(Peach*) My problem is now I am only getting Peach etc. and not the PEACH etc. or peach etc. Is there a way of getting my select statement to xlate and wilcard scan from the same select statement? Thank you in advance. Jerry

[Guest.Visitor]

Jerry, Assuming that your search criterion is always uppercase your should do something like : QRYSLT('%XLATE(DBFIELD QSYSTRNTBL) *EQ %WLDCRD("' *TCAT &SEARCH *TCAT '")') If you're using a CLP program and want to translate your criterion from mixed case to upper case, you should consider calling a 'C' function like ToUpper that you can call just by turning your CLP into an CLLE. Friendly yours. Bruno. Bruno_Couleau@Seagram.com or Bruno.Couleau@Wanadoo.fr