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 |