bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL UCASE() Function

Concept visual

MySQL UCASE() Function

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

Example

Convert the text to upper-case:

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

Definition and Usage

Formula

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

Formula

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

SELECT UCASE(CustomerName) AS UppercaseCustomerName

FROM Customers;

Previous

❮ MySQL Functions

Next

Previous

MySQL TRIM() Function

Next

MySQL UPPER() Function