Returns a Variant (String) containing the specified string, converted to uppercase.
Syntax
UCase ( string )
The required stringargument is any valid string expression. If string contains Null, Null is returned.
Remarks
Only lowercase letters are converted to uppercase; all uppercase letters and nonletter characters remain unchanged.
Query example
|
Expression |
Results |
|
SELECT Ucase(ProductDesc) AS Upper_ProductDesc FROM ProductSales; |
Converts the values from “ProductDesc” field into Uppercase and displays in column Upper_ProductDesc. |
VBA example
Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.
This example uses the UCase function to return an uppercase version of a string.
Dim LowerCase, UpperCaseLowerCase = "Hello World 1234" ' String to convert.UpperCase = UCase(LowerCase)' Returns "HELLO WORLD 1234".