On this page

    Categories: String


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


    LCASE(expression varchar) → varchar

    • expression: String to convert to lowercase.


    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.