Posted by
MS Access
UCase()
Function
Example
Convert the text in “CustomerName” to upper-case:
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
UCase(
text
)
Parameter Values
| Parameter | Description |
|---|---|
|
text |
Required. The string to convert |
Technical Details
| Works in: | From Access 2000 |
|---|