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