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 |