SQL INITCAP Function
SQL INITCAP() function is used to capitalized first letter of each word in a string. It increases the readability of the text. It converts the input string to uppercase the first letter of each word in a string and lowercase the other letters. It is mostly used on description fields:
Example:
The following SQL INITCAP statement returns ‘Abcd’ as output:
SELECT INITCAP(‘ABCD’) FROM dual;
Output:
Example 2:
The following SQL INITCAP Function will return employee names with capital first letter and rest of the name as lower letters:
SELECT INITCAP(first_name) FROM employee;
Output:
