Sunday, April 17, 2022

LCase Function [MS]

Returns a String that has been converted to lowercase.


LCase ( string )

The required stringargument is any valid string expression. If string contains Null, Null is returned.


Only uppercase letters are converted to lowercase; all lowercase letters and nonletter characters remain unchanged.

Query example



SELECT LCase(ProductDesc) AS Lower_ProductDesc FROM ProductSales;

Converts the values from "ProductDesc" field into Lowercase and displays in column Lower_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 LCase function to return a lowercase version of a string.

Dim UpperCase, LowerCase
Uppercase = "Hello World 1234" ' String to convert.
Lowercase = Lcase(UpperCase) ' Returns "hello world 1234"

String functions and how to use them

No comments:

Post a Comment

Search This Blog

Review guidelines for customizing a number format [MS]

Review guidelines for customizing a number format Excel for Microsoft 365...