UCASE() FUNCTION in MySQL

UCASE() FUNCTION The MySQL UCASE function is used to convert all characters in the specified string to uppercase. The various versions of MySQL supports the UCASE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.

Syntax:

UCASE( string )

Parameters: string: It is used to specify the string to modify.

Example:

mysql> SELECT UCASE ( ‘hello world 123);

Output:

'HELLO WORLD 123'

Explanation: All the letters are converted to uppercase.

Please follow and like us:
Content Protection by DMCA.com