This function is used to convert the first letter of each word of a string to upper case and all other letters to lower case.
initcap(string A)
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
A |
Yes |
STRING |
Text string to be converted |
The return value is of the STRING type. In the string, the first letter of each word is capitalized, and the other letters are lowercased.
The value Dli Sql is returned.
SELECT initcap("dLI sql");