sql capture substring code example
Example 1: grab part of a string sql
SELECT
SUBSTRING('SQLTutorial.org',
POSITION('.' IN 'SQLTutorial.org'));
Example 2: substring sql
SELECT SUBSTR(first_name, 0 , 3)
From employees;
SELECT
SUBSTRING('SQLTutorial.org',
POSITION('.' IN 'SQLTutorial.org'));
SELECT SUBSTR(first_name, 0 , 3)
From employees;