UPPER()
function returns a given string, an expression, or values in a column in all uppercase letters. The syntax of the function is illustrated below:
UPPER()
function.UPPER()
function.UPPER()
functionUPPER()
function works using an example with columns. We have a table named personal_details containing employee’s id, first_name, last_name, and gender of a retail store:
CONCAT()
function into one full_name column in uppercase.