MS Access UCase() Function

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