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

Last modified: February 27, 2023

Was this article helpful?