lcase

Returns "string_expression" with all uppercase characters shifted to lowercase.

Syntax

lcase ( string_expression )

Example

lcase ( [Sales (query)].[Sales staff].[Last name] )

Result

Returns last names with no uppercase letters.