LCASE

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

Syntax

LCASE(expression varchar) → varchar

expression: String to convert to lowercase.

Examples

LCASE example

SELECT LCASE('A GUIDE to data Lakehouses')
-- a guide to data lakehouses

LCASE example

SELECT Category, LCASE(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

LCASE is a synonym for LOWER.

Was this page helpful?

Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.