SQL iQuery Script Built-in Function

toUpper / toLower

Convert data to upper or lower case.

The TOUPPER() built-in function returns the upper case equivalent of the value specified for parameter 1.
The TOLOWER() built-in function returns the lower case equivalent of the value specified for parameter 1.

Syntax

• eval &hex = tohex( <Session Variable or value > );

The ISHEX() passes the first parameter to the cvthc MI instruction. That instruction "unfolds" the characters; creating 2 hexadecimal bytes for each single byte of parameter 1. For example, the string '38' is translated to 'F3F8'.

Parameters

1. The name of an iQuery Session Variable to be converted to upper or lower case.

#default &Comp = 'IBM Corp.'
SELECT upper(corpname) INTO &CompName
FROM CUSTMAST
WHERE CUSTNO = 5250;

if (toUpper(&comp) = &compName);
  #msg Company: &compname
else;
  // continue normally
endif;