SQL•SQL References

MS Access UCase() Function

Example

 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	Description
text	Required. The string to convert

Works in:	From Access 2000

Loading lesson path

SQL•SQL References

Example

 SELECT UCASE(CustomerName) AS UppercaseCustomerName
FROM Customers;

The UCase() function converts a string to upper-case.

Tip

Also look at the LCase() function.

Syntax

UCase(
text
)

Parameter	Description
text	Required. The string to convert

Works in:	From Access 2000