SingleStore Managed Service

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 |
+-------------------------------------+