SWAPCASE

This page describes the SWAPCASE function in Lenses SQL.

SWAPCASE(expr)

Swaps the case of a string expression.

Available in:

ProcessorsSQL Studio

Sample code:

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

Output:

{
  "value": {
    "SWAPCASE": "jOSE",
    "first_name": "Jose"
  }
}

Last updated

Logo

2024 © Lenses.io Ltd. Apache, Apache Kafka, Kafka and associated open source project names are trademarks of the Apache Software Foundation.