Sql server substring

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

Sql substring

-- substr(string, start, [, length ])
SELECT substr('Hello World', 1, 3) ;      -- Hel
SELECT substr('Hello World', 4, 5) ;      -- lo Wo
SELECT substr('Hello World', 4);          -- lo World
SELECT substr('Hello World', -3);         -- rld

Grab part of a string sql

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

Source: sqltutorial.org

Sql substring

SELECT SUBSTRING(your String here, Int Start, String length) AS OutPutString;

Similar codes

0 vote363 views1 answer
Alter rename command in mysql
SQL
1 vote345 views1 answer
Postgres concat_ws
SQL
0 vote340 views1 answer
Mysql show create db
SQL
0 vote347 views1 answer
Number(10 2) in sql means
SQL
0 vote401 views1 answer
Sql trim whitespace
SQL
6 votes360 views3 answers
Update with inner join postgres
SQL
1 vote362 views2 answers
Insert sqlite
SQL
1 vote349 views1 answer
Mysql select another database
SQL
0 vote344 views1 answer
Get number of tables in database sql
SQL
1 vote333 views1 answer
Sql get missing id
SQL