Example
Convert the text in "CustomerName" to upper-case:
sql
SELECT UCASE(CustomerName) AS UppercaseCustomerName
FROM Customers;
Definition and Usage
The UCase() function converts a string to upper-case.
Tip: Also look at the LCase() function.
Syntax
text
UCase(text)
Parameter Values
| Parameter | Description |
|---|---|
| text | Required. The string to convert |
Technical Details
| Works in: | From Access 2000 |
|---|