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 vote164 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote186 views1 answer
Mysql isshow
SQL
0 vote249 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
6 votes225 views4 answers
Mysql get random row
SQL
0 vote359 views1 answer
Current month transactions in mysql
SQL
0 vote173 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
11 votes226 views2 answers
Import sql file laravel cmd
SQL
9 votes348 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote196 views1 answer
Not equal to blank in mysql
SQL
2 votes199 views3 answers
Write sql query to find the second highest salary of employee
SQL