UPPER

Description

The UPPER function converts a string to uppercase. (RedShift SQL Language Reference Upper function)

Grammar Syntax

UPPER ( string )

This function is fully supported by Snowflake.

Sample Source Patterns

Input Code:

Redshift

IN -> Redshift_01.sql

CREATE TABLE test_upper_function (
    col1 varchar
 );

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

SELECT  UPPER(COL1),
        "UPPER"(COL1),
        UPPER('vaLues') 
FROM test_upper_function;

Results

UPPER(COL1)	"UPPER"(COL1)	UPPER('vaLues')
TEST	TEST	VALUES
TEST	TEST	VALUES
TEST	TEST	VALUES

Output Code:

Snowflake

OUT -> Redshift_01.sql

CREATE TABLE test_upper_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_upper_function
VALUES ('test'),
       ('Test'),
       ('TEST');

SELECT  UPPER(COL1),
        UPPER(COL1),
        UPPER('vaLues')
FROM
        test_upper_function;

Results

UPPER(COL1)	"UPPER"(COL1)	UPPER('vaLues')
TEST	TEST	VALUES
TEST	TEST	VALUES
TEST	TEST	VALUES

Related EWIs

There are no known issues.