SUBSTRING

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     |