Podcast
Questions and Answers
Which function is used to convert a string to lower-case in MS Access?
Which function is used to convert a string to lower-case in MS Access?
- ConvertToLowerCase()
- LowerCase()
- UCase()
- LCase() (correct)
What is the syntax for using the LCase() function in MS Access?
What is the syntax for using the LCase() function in MS Access?
- text(LCase)
- LCaseString(text)
- StringToLowerCase(text)
- LCase(text) (correct)
Which SQL statement can be used to convert the text in the 'CustomerName' column of the 'Customers' table to lower-case?
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; (correct)
- SELECT CustomerName TO LOWERCASE AS LowercaseCustomerName FROM Customers;
- SELECT LOWER(CustomerName) AS LowercaseCustomerName FROM Customers;
- SELECT CONVERT(CustomerName, lcase) AS LowercaseCustomerName FROM Customers;