The UPPER()
function converts a string sent as a parameter to uppercase.
Figure 1 shows a visual representation of the UPPER()
function.
UPPER(string)
The UPPER()
function takes in a string that needs to be converted to uppercase as a required parameter.
The UPPER()
function returns the uppercase version of a string sent as a parameter.
If a number is sent as a parameter, then
UPPER()
returns the number unchanged.
-- stringSELECT UPPER('hello');-- numberSELECT UPPER(123);