INITCAP

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Syntax

SQL

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

SQL

SELECT INITCAP("alan storm");

+-----------------------+
| INITCAP("alan storm") |
+-----------------------+
| Alan Storm            |
+-----------------------+

Example 2

SQL

SELECT * FROM stockN;

+------+-------------+-------+
| ID   | City        | Count |
+------+-------------+-------+
| XCN  | new york    |    45 |
| ZDF  | washington  |    20 |
| WVM  | boston      |    42 |
| TYN  | los angeles |    15 |
| XCN  | chicago     |    32 |
+------+-------------+-------+

SQL

SELECT ID, INITCAP(City) FROM stockN;

+------+---------------+
| ID   | INITCAP(City) |
+------+---------------+
| XCN  | New York      |
| ZDF  | Washington    |
| XCN  | Chicago       |
| WVM  | Boston        |
| TYN  | Los Angeles   |
+------+---------------+

Example 3

SQL

SELECT INITCAP(CONCAT("jade", " ", "blue")) AS Result;

+-----------+
| Result    |
+-----------+
| Jade Blue |
+-----------+

Example 4

SQL

SELECT INITCAP("SUSAN GRAHAM, C@ss n1te, dEaN wHiTe") AS Results;

+-------------------------------------+
| Results                             |
+-------------------------------------+
| Susan Graham, C@Ss N1te, Dean White |
+-------------------------------------+

Last modified: February 27, 2023