1 of 1

CAPITALIZE

This page describes the CAPITALIZE function in Lenses SQL.

CAPITALIZE(expr)

Capitalize the first letter of the expression.

Available in:

Processors

SQL Studio

✓

Sample code:

USE `kafka`;
SELECT 
    CAPITALIZE(status), 
    status 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "CAPITALIZE": "Unverified",
    "status": "unverified"
  }
}