Hi all,

This should hopefully be a real easy one, but at the moment I don’t know how to do it.

We receive report selection criteria into our reports from htm screens. When the user inputs characters as lower case the report does not find the data as everything in our database is in upper case.

I have found the UPCASE command, but this is for converting database data to upper. I need covert a program variable to upper, before querying the database with it.

Thanks

Mark.

You can use UPCASE for what you need to do:


-SET &INPUTVAR = UPCASE(&INPUTVAR.LENGTH,&INPUTVAR,'A&INPUTVAR.LENGTH');

Perfect! Thanks Mickey

I didn't realise the .LENGTH function was available.

Another option is to use javascript and convert it to upper case. This way the user will realize that it should be upper case.

Scott

-SET &MYNAME = 'SUSANNAH   ';
-*this gives you 11
-TYPE &MYNAME.LENGTH
-*but this gives you 8
-SET &ALEN = ARGLEN( &MYNAME.LENGTH , &MYNAME , 'I2');
-TYPE &ALEN