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);