Tag: sql substring function

SQL SUBSTRING Function

Example

Extract 3 characters from a string, starting in position 1:

SELECT SUBSTRING('SQL Tutorial', 1, 3) AS ExtractString;

Definition and Usage

The SUBSTRING() function extracts some characters from a string.

Syntax

SUBSTRING(string, start, length)

Continue reading SQL SUBSTRING Function

SQL LEFT Function

Example

Extract 3 characters from a string (starting from left):

SELECT LEFT('SQL Tutorial', 3) AS ExtractString;

Definition and Usage

The LEFT() function extracts a number of characters from a string (starting from left).

Syntax

LEFT(string, number_of_chars)

Continue reading SQL LEFT Function