Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
INITCAP
Converts the first letter of each word in a string to upper case.
Syntax
INITCAP(string_exp)
Arguments
string_exp: any valid string expression, a column name, or a string returned from another function
Return Type
String
Examples
Example 1
SELECT INITCAP("alan storm");
****
+-----------------------+
| INITCAP("alan storm") |
+-----------------------+
| Alan Storm |
+-----------------------+
Example 2
SELECT * FROM stockN;
****
+------+-------------+-------+
| ID | City | Count |
+------+-------------+-------+
| XCN | new york | 45 |
| ZDF | washington | 20 |
| WVM | boston | 42 |
| TYN | los angeles | 15 |
| XCN | chicago | 32 |
+------+-------------+-------+
SELECT ID, INITCAP(City) FROM stockN;
****
+------+---------------+
| ID | INITCAP(City) |
+------+---------------+
| XCN | New York |
| ZDF | Washington |
| XCN | Chicago |
| WVM | Boston |
| TYN | Los Angeles |
+------+---------------+
Example 3
SELECT INITCAP(CONCAT("jade", " ", "blue")) AS Result;
****
+-----------+
| Result |
+-----------+
| Jade Blue |
+-----------+
Example 4
SELECT INITCAP("SUSAN GRAHAM, C@ss n1te, dEaN wHiTe") AS Results;
****
+-------------------------------------+
| Results |
+-------------------------------------+
| Susan Graham, C@Ss N1te, Dean White |
+-------------------------------------+
