Collections:
UPPER() - Convert String to Upper Case
How to convert a string to upper case using the UPPER() function?
✍: FYIcenter.com
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
2023-11-13, 302🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...