General MySQL Oracle SQL Server

UPPER() - Convert String to Upper Case

Q

How to convert a string to upper case using the UPPER() function?

✍: FYIcenter.com

A

UPPER(str) is a MySQL built-in function that converts all characters of a given into upper case characters. For example: 

SET @str = 'dba.FYIcenter.com';

SELECT UPPER(@str);
  -- +-------------------+
  -- | UPPER(@str)       |
  -- +-------------------+
  -- | DBA.FYICENTER.COM |
  -- +-------------------+

Reference information of the UPPER() function: 

UPPER(str): modstr
  Returns the string str with all characters changed to uppercase
  according to the current character set mapping, or NULL if str is NULL.
  The default character set is utf8mb4.

Arguments, return value and availability:
  str: Required. The string to be converted.
  modstr: Return value. The converted string.
  Available since MySQL 4.0.

Related MySQL functions:

 

⇒ WEIGHT_STRING() - String Sorting Weight

⇐ UNHEX() - HEX to String Conversion

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References

2023-11-13, 1426🔥, 0💬

General MySQL Oracle SQL Server