SUBSTRING

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Applies to

• SQL Server

• Azure Synapse Analytics

Description

Returns a character expression after it removes leading blanks (RTRIM in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

SUBSTRING( string_expression, start, length )

Snowflake SQL

Snowflake SQL complete documentation

SUBSTR( <base_expr>, <start_expr> [ , <length_expr> ] )

SUBSTRING( <base_expr>, <start_expr> [ , <length_expr> ] )

JavaScript

Custom function used to emulate the behavior

string.substring( indexA [, indexB])

Examples

SQL Server

Input:

IN -> SQLServer_01.sql

SELECT SUBSTRING('abcdef', 2, 3) AS SOMETEXT;  

Output:

SOMETEXT|
--------+
bcd     |

Snowflake SQL

Code:

OUT -> SQLServer_01.sql

SELECT SUBSTRING('abcdef', 2, 3) AS SOMETEXT;  

Result:

SOMETEXT|
--------+
bcd     |

JavaScript

Code:

CREATE OR REPLACE FUNCTION REPLACER_LENGTH(str varchar, index float, length float)
  RETURNS string
  LANGUAGE JAVASCRIPT
AS
$$
    var start = INDEX - 1;
    var end = STR.length - (LENGTH - 1);
    return STR.substring(start, end);
$$;

SELECT REPLACER_LENGTH('abcdef', 2, 3) AS SOMETEXT;

Result:

SOMETEXT|
--------+
bcd     |

Known Issues

No issues were found.

Related EWIs

No related EWIs.