Help Center/
Data Lake Insight/
SQL Syntax Reference (To Be Offline)/
Spark SQL Syntax Reference (Unavailable Soon)/
Built-in Functions/
String Functions/
initcap
Updated on 2023-10-25 GMT+08:00
initcap
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.
Syntax
initcap(string A)
Parameters
|
Parameter |
Mandatory |
Type |
Description |
|---|---|---|---|
|
A |
Yes |
STRING |
Text string to be converted |
Return Values
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.
Example Code
The value Dli Sql is returned.
SELECT initcap("dLI sql");
Parent topic: String Functions
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
