SUBSTRING

Description

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

Sample Source Pattern

Syntax

SUBSTRING( string_expression, start, length )

Examples

Input:

IN -> SQLServer_01.sql
SELECT SUBSTRING('abcdef', 2, 3) AS SOMETEXT;  

Output:

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

Last updated