PostgreSQL – LOWER Function

ByAdmin

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

Here’s the basic syntax of the LOWER function:

LOWER(string)
  • string is the string or column that you want to convert to lowercase.

Here’s an example of using the LOWER function:

SELECT LOWER('Hello, World!'); -- Returns 'hello, world!'

You can also use the LOWER 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 last names to lowercase like this:

SELECT LOWER(name) FROM employees;

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

Similar Posts

PostgreSQL – TRANSLATE Function

ByAdmin

The TRANSLATE function is used to replace all occurrences of a set of characters in a given string with corresponding characters from another set. This function is particularly useful for performing character-level substitutions or transformations. The syntax of the TRANSLATE function is as follows: TRANSLATE(string, from_set, to_set) where string is the input string in which…

PostgreSQL – MD5 Function

ByAdmin

The MD5 function is used to calculate the MD5 hash value of a given input string. MD5 (Message Digest Algorithm 5) is a widely used cryptographic hash function that produces a fixed-size 128-bit (16-byte) hash value, typically represented as a 32-character hexadecimal number. The syntax of the MD5 function is as follows: MD5(string) where string…