UCase
Returns a string that has been converted to upper case.
Syntax
UCase(Val)
Parameter
Val
Type: Text
Text value to be converted to upper case.
(return)
Type: Text
Uppercase copy of Val.
Remarks
The input string is converted to upper case, according to the rules of the input locale.
If the current data value is NULL, Val is "" and the return value is "".
How you specify a text string as an argument depends on whether you are using the function in an SQL query or in mrScriptBasic or mrScriptMetadata. In an SQL query, enclose text strings in single quotation marks ' '. In mrScriptBasic or mrScriptMetadata, enclose text strings in double quotation marks " ".
Examples
This example returns an uppercase copy of the contents of the name variable:
name.UCase()
The next example uses
Trim and
Mid in addition to the UCase function. The example returns characters 5-10 of the
name variable converted to upper case and with any leading or trailing spaces removed:
Trim(UCase(name.Mid(4, 5)))
See also