February 02, 2007, 09:25 AMmark66
Converting input variable to upper case?
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.
February 02, 2007, 09:45 AMmgrackin
You can use UPCASE for what you need to do:
-SET &INPUTVAR = UPCASE(&INPUTVAR.LENGTH,&INPUTVAR,'A&INPUTVAR.LENGTH');
February 02, 2007, 10:40 AMmark66
Perfect! Thanks Mickey
I didn't realise the .LENGTH function was available.
February 02, 2007, 10:52 AMTexasStingray