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 vote354 views1 answer
Sql gather statistics to increase performance
SQL
0 vote327 views1 answer
Select from another database
SQL
0 vote372 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote281 views1 answer
Denied
SQL
0 vote351 views1 answer
Postgresql delete type
SQL
0 vote347 views1 answer
Mysql multiple primary keys
SQL
0 vote355 views1 answer
Mssql + bit + in python orm
SQL
5 votes367 views4 answers
Upload database mysql command line
SQL
1 vote324 views3 answers
Postgresql connect to database
SQL
0 vote336 views1 answer
Hibernate with springboot mysql
SQL