LOWER (Lakehouse v1)
Returns a string with all characters changed to lowercase.
Analyze Syntax
Section titled “Analyze Syntax”func.lower(<str>)Analyze Examples
Section titled “Analyze Examples”func.lower('Hello, PlaidCloud!')┌──────────────────────────────────┐│ func.lower('Hello, PlaidCloud!') │├──────────────────────────────────┤│ hello, plaidcloud! │└──────────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”LOWER(<str>)Aliases
Section titled “Aliases”Return Type
Section titled “Return Type”VARCHAR
SQL Examples
Section titled “SQL Examples”SELECT LOWER('Hello, Databend!'), LCASE('Hello, Databend!');
┌───────────────────────────────────────────────────────┐│ lower('hello, databend!') │ lcase('hello, databend!') │├───────────────────────────┼───────────────────────────┤│ hello, databend! │ hello, databend! │└───────────────────────────────────────────────────────┘