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

1 vote192 views2 answers
Begin transaction sql
SQL
2 votes170 views1 answer
Update with join sql server
SQL
1 vote208 views1 answer
Increase date by one day in sql oracle
SQL
1 vote185 views1 answer
Add many column to sap iq table
SQL
13 votes204 views1 answer
Sql join 3 tables on id
SQL
0 vote206 views1 answer
Oracle enable chain
SQL
0 vote178 views5 answers
Linq cheat sheet
SQL
0 vote184 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote171 views1 answer
Remove default constraint sql server
SQL
0 vote192 views1 answer
Spark sql grows beyond 64 kb
SQL