Change the text to uppercase.
SELECT UPPER(“SQL Tutorial is FUN!”); |
The UPPER() function converts a string to uppercase.
Note: This function is equivalent to the UCASE() function.
UPPER(text) |
Parameter |
Description |
text |
Mandatory. Specifies the string to be converted. |
Works in: | From MySQL 4.0 |
Change the text in “CustomerName” to uppercase.
SELECT UPPER(CustomerName) AS UppercaseCustomerName FROM Customers; |