INITCAP
On this page
Converts the first letter of each word in a string to upper case.
Syntax
INITCAP(string_exp)
Arguments
-
string_: any valid string expression, a column name, or a string returned from another functionexp
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 |
+-------------------------------------+Last modified: February 27, 2023