Convert the text to upper-case:
SELECT UPPER("SQL Tutorial is FUN!");
The UPPER() function converts a string to upper-case.
Note: This function is equal to the UCASE() function.
UPPER(text)
| Parameter | Description |
|---|---|
| text | Required. The string to convert |
| Works in: | From MySQL 4.0 |
|---|
Convert the text in "CustomerName" to upper-case:
SELECT UPPER(CustomerName) AS UppercaseCustomerName
FROM Customers;
Author: Kareem Mueller DO
Last Updated:
Views: 6422
Rating: 4.6 / 5 (66 voted)
Reviews: 89% of readers found this page helpful
Name: Kareem Mueller DO
Birthday: 1997-01-04
Address: Apt. 156 12935 Runolfsdottir Mission, Greenfort, MN 74384-6749
Phone: +16704982844747
Job: Corporate Administration Planner
Hobby: Mountain biking, Jewelry making, Stone skipping, Lacemaking, Knife making, Scrapbooking, Letterboxing
Introduction: My name is Kareem Mueller DO, I am a vivacious, super, thoughtful, excited, handsome, beautiful, combative person who loves writing and wants to share my knowledge and understanding with you.