PostgreSQL – UPPER Function

ByAdmin

The UPPER function is used to convert all characters in a given string to uppercase. It takes a string as an argument and returns a new string where all alphabetic characters have been converted to their uppercase equivalents.

Here’s the basic syntax of the UPPER function:

UPPER(string)
  • string is the string or column that you want to convert to uppercase.

Here’s an example of using the UPPER function:

SELECT UPPER('Hello, World!'); -- Returns 'HELLO, WORLD!'

You can also use the UPPER function with column values in a table. For instance, if you have a table named employees with a column named name, you can convert all first names to uppercase like this:

SELECT UPPER(name) FROM employees;

This query will return a result set with all the name values in uppercase.

Similar Posts

PostgreSQL – REPLACE Function

ByAdmin

The REPLACE function is used to replace all occurrences of a specified substring within a given string with another substring. The syntax of the REPLACE function is as follows: REPLACE(string, old_substring, new_substring) where string is the input string in which you want to perform replacements, and old_substring is the substring you want to replace within…