LOWER
Description
Sample Source Pattern
Syntax
LOWER ( character_expression ) LOWER( <expr> )String.toLowerCase( )Examples
SELECT LOWER('YOU ARE A PREDICTION OF THE GOOD ONES') AS LOWERCASELOWERCASE |
-------------------------------------+
you are a prediction of the good ones|SELECT LOWER('YOU ARE A PREDICTION OF THE GOOD ONES') AS LOWERCASELOWERCASE |
-------------------------------------+
you are a prediction of the good ones|CREATE OR REPLACE FUNCTION to_lower(str varchar)
RETURNS string
LANGUAGE JAVASCRIPT
AS
$$
return STR.toLowerCase();
$$;
SELECT TO_LOWER('YOU ARE A PREDICTION OF THE GOOD ONES') LOWERCASE;LOWERCASE |
-------------------------------------+
you are a prediction of the good ones|Last updated
Was this helpful?