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