topic Re: Convert to upper case during select in Application Development and Automation Discussions

Convert to upper case during select

Former Member — Thu, 15 Oct 2009 13:44:54 GMT

High,

i have selection screen with select-options. during datatransfer from screen to programm, the options will be converted to upper case. in my table i have values in mixed case so they can't be found in my select statement. is there a possibility to convert the values of a specific column during the select so that they can be compared with the upper case select-options from the selection screen?

thanks for your answers!

harry

Re: Convert to upper case during select

Former Member — Thu, 15 Oct 2009 13:47:21 GMT

Yes - and if you search the forum, you'll see how.

Rob

Re: Convert to upper case during select

Sm1tje — Thu, 15 Oct 2009 13:48:14 GMT

Error!!

Re: Convert to upper case during select

Former Member — Fri, 16 Oct 2009 05:45:35 GMT

Thanks for your help, guys!

Harry

Re: Convert to upper case during select

nikhil_chitre — Fri, 16 Oct 2009 05:52:34 GMT

Find the sample code below

DATA text TYPE string.

text = `Careful with that Axe, Eugene`.

TRANSLATE text TO UPPER CASE.

Regards,

Nikhil