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. See also
Specifying text strings as arguments.
(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 "".
Examples
This example returns an uppercase copy of the contents of the name variable:
name.UCase()
The next example uses the
Trim and
Mid functions 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