MySQL UCASE() Function

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP







<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]
-->



MySQL UCASE() Function


❮ MySQL Functions




Example


Convert the text to upper-case:



SELECT UCASE("SQL Tutorial is FUN!");

Try it Yourself »

Definition and Usage


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


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



Syntax



UCASE(text)


Parameter Values





Parameter Description
text Required. The string to convert

Technical Details




Works in: From MySQL 4.0

More Examples



Example


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



SELECT UCASE(CustomerName) AS UppercaseCustomerName
FROM Customers;

Try it Yourself »


❮ MySQL Functions


-