INITCAP Function

INITCAP

INITCAP function set the first character in each word into uppercase and other are lower in a string.

This will capitalize the initial letter of the string.

Syntax: initcap (string)
Ex:
SQL> select initcap(‘computer’) from dual;

output Computer

select initcap(‘this Is mY cAr’) from dual;

output This Is My Car

INITCAP function in SQL

Leave a Reply