Convert the text to upper-case:
SELECT UCASE("SQL Tutorial is FUN!");
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;
Author: Arielle Torp
Last Updated:
Views: 5696
Rating: 4 / 5 (61 voted)
Reviews: 84% of readers found this page helpful
Name: Arielle Torp
Birthday: 1997-09-20
Address: 87313 Erdman Vista, North Dustinborough, WA 37563
Phone: +97216742823598
Job: Central Technology Officer
Hobby: Taekwondo, Macrame, Foreign language learning, Kite flying, Cooking, Skiing, Computer programming
Introduction: My name is Arielle Torp, I am a comfortable, kind, zealous, lovely, jolly, colorful, adventurous person who loves writing and wants to share my knowledge and understanding with you.