Questions and Answers
Which function is used to convert a string to lower-case in MS Access?
LCase()
What is the syntax for using the LCase() function in MS Access?
LCase(text)
Which SQL statement can be used to convert the text in the 'CustomerName' column of the 'Customers' table to lower-case?
SELECT LCASE(CustomerName) AS LowercaseCustomerName FROM Customers;