Outdated Version

You are viewing an older version of this section. View current production version.

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("SAMUEL GRAY, C@ss n1te, dEaN wHiTe") AS Results;
****
+------------------------------------+
| Results                            |
+------------------------------------+
| Samuel Gray, C@Ss N1te, Dean White |
+------------------------------------+