Change the text in “CustomerName” to lowercase.
SELECT LCASE(CustomerName) AS LowercaseCustomerName FROM Customers; |
The LCase() function transforms a string into lowercase.
Tip: Consider the UCase() function as well.
LCase(text) |
Parameter |
Description |
text |
Required. Specifies the string that will be converted to lowercase. |
Works in: |
From Access 2000 |