Lcase

Convert a string to lower-case.

Syntax
      Lcase(string)

Key
   string    A string or string expression.

The Lcase() function can be used in VBA or in an SQL query.

Lcase() will return a Variant, you can also use Lcase$() to return a String.
You should use Lcase() if there is any chance of a Null value, since assigning Null to a String will raise an error.

Examples

Dim strDemo as String
strDemo = Lcase("12 ACACIA Gardens")
Msgbox strDemo
Returns "12 acacia gardens"

“Graze on my lips, and if those hills be dry, Stray lower, where the pleasant fountains lie” ~ Shakespeare (Venus and Adonis)

Related:

UCase - Uppercase String
Swap Case - Reverse CAPS lock


© Copyright SS64.com 1999-2016
Some rights reserved