MS Access UCase() Function

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.

UCase( text)

Parameter	Description
text	Required. The string to convert

Works in:	From Access 2000