INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric. char can be of any of …

Jul 23, 2025 · This guide explores how to capitalize the first letter of a string in SQL, using functions like UPPER (), LOWER (), and SUBSTRING () in MySQL, ensuring your data is presented correctly and …

If you are looking for the answer to the same question in Oracle/PLSQL then you may use the function INITCAP. Below is an example for the attribute dname from a table department which has the values …

Jan 6, 2018 · The INITCAP function capitalises the first letter of each word. It translates a specified string into another string that has the first letter of each word capitalised, and all other letters in lower …

This tutorial shows you how to use the Oracle INITCAP () function to convert a string to proper case.

What is INITCAP in SQL? INITCAP() is a string function that capitalizes the first letter of each word in a given string while converting all other letters to lowercase.

When specified as an empty string (that is, ''), INITCAP ignores all delimiters, including whitespace characters, in the input expression. The input expression is treated as a single, continuous word.

This Oracle tutorial explains how to use the Oracle / PLSQL INITCAP function with syntax and examples. The Oracle / PLSQL INITCAP function sets the first character in each word to uppercase …

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;

SQL INITCAP () Function return capitalize string/char (capitalize first letter of each word). SQL INITCAP () function supported Oracle SQL version.