Skip to main content
Version: current [25.x]

Categories: String

LOWER

Returns the input expression with all the characters converted to lowercase.

Syntax​

LOWER(expression varchar) → varchar​

  • expression: String to convert to lowercase.

Examples

LOWER example 
SELECT LOWER('A GUIDE to data Lakehouses')
-- a guide to data lakehouses
LOWER example 
SELECT Category, LOWER(Category) 
  FROM Samples."samples.dremio.com"."SF_incidents2016.json" 
  LIMIT 3
-- Category, EXPR$1
-- WEAPON LAWS, weapon laws
-- WEAPON LAWS, weapon laws
-- WARRANTS, warrants

Usage Notes​

LOWER is a synonym for LCASE.