CodesJava

Easy learning with example program codes

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:
error









Copyright © 2019 CodesJava DMCA.com Protection Status