Using UPCASE in a FEX

[LeonelSanchezJr]

I need to convert a &VARIABLE being passed to a FEX into UPPERCASE in order to avoid using UPPER() in my SQL Passthrus.

Thanks,

Leo ;-)

 

[NorthNone]

Be it ever so inelegant, this worked for me when I needed to convert something to upper case. Original value was stored in &DRAWBUD1, upper case in &DRAWBUD.

-SET &DRAWBUD = UPCASE(&DRAWBUD1.LENGTH, &DRAWBUD1, 'A3');

Surely someone out there knows a better way.

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[focwizard]

What you may want to do is the following:

-SET &LL = &DRAWBUD.LENGTH;
-SET &DRAWBUD = UPCASE(&LL, &DRAWBUD1, 'A&LL.EVAL');

By setting the length of the variable to an 'amper' variable, you can use the '.EVAL' operator in the last argument, to automatically adjust for ANY input value.

 

[NorthNone]

Great idea, FocWizard!

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.