# INITCAP

Converts the first letter of each word in a string to upper case.

## 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");

```

```output

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

```

## Example 2

```sql
SELECT * FROM stockN;

```

```output

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

```

```output

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

```

```output

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

```

## Example 4

```sql

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

```

```output

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

```

***

Modified at: February 27, 2023

Source: [/db/v9.1/reference/sql-reference/string-functions/initcap/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/string-functions/initcap/)

(An index of the documentation is available at /llms.txt)