PostgreSQL INITCAP() function
INITCAP() function
The PostgreSQL initcap() function is used to convert the first letter of each word to upper case and the remaining to lower case.
Syntax:
initcap(<string>)
PostgreSQL Version: 9.3
Pictorial Presentation of PostgreSQL INITCAP() function
Example: PostgreSQL INITCAP() function:
In the example below the initcap function returns to convert the first character or each word in capital and rest are in small letter.
Code:
SELECT initcap('RABINDRANATH TAGORE')
AS "First Character of each word Capital";
Sample Output:
First Character of each word Capital -------------------------------------- Rabindranath Tagore (1 row)
Sample Table: employees
Example of PostgreSQL INITCAP() function using column with nested functions:
If we want to display the first_name, last_name and name in lower case and name in proper case i.e. first letter of each word in capital for those employees who belongs to the department which ID 100, from the employees table, the following sql statement can be used:
Code:
SELECT first_name, last_name,
concat(lower(first_name),' ', lower(last_name)) "Name of Employee in lower case",
initcap(concat(first_name,' ', last_name)) "Proper Name"
FROM employees
WHERE department_id=100;
Sample Output:
first_name | last_name | Name of Employee in lower case | Proper Name -------------+-----------+--------------------------------+------------------- Nancy | Greenberg | nancy greenberg | Nancy Greenberg Daniel | Faviet | daniel faviet | Daniel Faviet John | Chen | john chen | John Chen Ismael | Sciarra | ismael sciarra | Ismael Sciarra Jose Manuel | Urman | jose manuel urman | Jose Manuel Urman Luis | Popp | luis popp | Luis Popp (6 rows)
Previous: CONCAT function
Next: LEFT function
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join