This article is tagged with: Sql server substring and mysql

sql server substring

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

substring sql

SELECT SUBSTRING('SQL Tutorial', 4, (LENGTH('SQL Tutorial'))
AS LastCharactersString;
//Result -> Tutorial

grab part of a string sql

SELECT
    SUBSTRING('SQLTutorial.org',
        POSITION('.' IN 'SQLTutorial.org'));

This article is tagged with: Sql server substring and mysql