On this page

    Categories: String


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


    LOWER(expression varchar) → varchar

    • expression: String to convert to lowercase.


    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.