MS Access LCase() Function

Posted by

MS Access

LCase()

Function

Example

Convert the text in “CustomerName” to lower-case:

SELECT LCASE(CustomerName) AS LowercaseCustomerName
FROM Customers;


Definition and Usage

The LCase() function converts a string to lower-case.


Tip:

Also look at the
UCase()
function.

Syntax

LCase(

text

)

Parameter Values

Parameter Description

text
Required. The string to convert

Technical Details

Works in: From Access 2000