SQL String Function UPPER()

In SQL, the UPPER() function is used to convert a string to uppercase. It takes a single argument, which is the string to be converted.

Here is an example of using the UPPER() function:

SELECT UPPER('Hello, World!') AS uppercase_string;

In this example, the UPPER() function is used to convert the string 'Hello, World!' to uppercase. The resulting string, 'HELLO, WORLD!', is returned as the result of the query.

The UPPER() function can be useful when working with text data that needs to be formatted consistently, or when performing case-insensitive searches.

It's important to note that the UPPER() function only affects alphabetic characters, and does not affect any other characters (such as numbers or punctuation). As always, it's important to consult the documentation for your specific database system to ensure that you are using the function correctly.