LOWER
Description
Converts a string to lowercase (LOWER in Transact-SQL).
Sample Source Pattern
Syntax
LOWER ( character_expression ) Snowflake SQL complete documentation
LOWER( <expr> )JavaScript SQL complete documentation
String.toLowerCase( )Examples
Code:
SELECT LOWER('YOU ARE A PREDICTION OF THE GOOD ONES') AS LOWERCASE;Output:
LOWERCASE |
-------------------------------------+
you are a prediction of the good ones|Code:
SELECT LOWER('YOU ARE A PREDICTION OF THE GOOD ONES') AS LOWERCASE;Output:
LOWERCASE |
-------------------------------------+
you are a prediction of the good ones|Code:
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;Output:
LOWERCASE |
-------------------------------------+
you are a prediction of the good ones|Last updated