MySQL UCASE() Function

MySQL Functions : Convert the text to upper-case

Definition and Usage

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

Note: This function is equal to the UPPER() function.

UCASE(text)

Parameter	Description
text	Required. The string to convert

Works in:	From MySQL 4.0

Convert the text in "CustomerName" to upper-case:

SELECT UCASE(CustomerName) AS UppercaseCustomerName
FROM Customers;

Email:

Content: