Convert the text in the “CustomerName” to uppercase.
SELECT UCASE(CustomerName) AS UppercaseCustomerName FROM Customers; |
The UCase() function converts a string to uppercase.
Tip: Consider also using the LCase() function for converting to lowercase.
UCase(text) |
Parameter |
Description |
text |
Required: The string that you want to convert (to uppercase or lowercase). |
Works in: |
From Access 2000 |