UNCAPITALIZE

This page describes the UNCAPITALIZE function in Lenses SQL.

UNCAPITALIZE(expr)

Change the first letter of each word in the expression to lowercase.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
    UNCAPITALIZE(first_name), 
    first_name 
FROM users-topic
LIMIT 1;

Output:

{
  "value": {
    "UNCAPITALIZE": "jose",
    "first_name": "Jose"
  }
}