LOWER

Description

The LOWER function converts a string to lowercase. (RedShift SQL Language Reference Lower function)

Grammar Syntax

LOWER ( string )

This function is fully supported by Snowflake.

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE TABLE test_lower_function (
    col1 varchar
 );

INSERT INTO test_lower_function
VALUES ('test'),
       ('Test'),
       ('TEST');

SELECT  LOWER(COL1),
        "LOWER"(COL1),
        LOWER('vaLues')
FROM test_lower_function;

Results

LOWER(COL1)	"LOWER"(COL1)	LOWER('vaLues')
test	test	values
test	test	values
test	test	values

Output Code:

Snowflake

OUT -> Redshift_01.sql

CREATE TABLE test_lower_function (
    col1 varchar
 )
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "11/21/2024",  "domain": "test" }}';

INSERT INTO test_lower_function
VALUES ('test'),
       ('Test'),
       ('TEST');

SELECT  LOWER(COL1),
        LOWER(COL1),
        LOWER('vaLues')
FROM
        test_lower_function;

Results

LOWER(COL1)	"LOWER"(COL1)	LOWER('vaLues')
test	test	values
test	test	values
test	test	values

Related EWIs

There are no known issues.