Sunday, July 3, 2022

UCase Function [MS]

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, UpperCase
LowerCase = "Hello World 1234" ' String to convert.
UpperCase = UCase(LowerCase)
' Returns "HELLO WORLD 1234".

String functions and how to use them

No comments:

Post a Comment

Search This Blog

Work in Outlook People [MS]

Work in Outlook People Outlook on the web More... Less ...