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 vote204 views1 answer
Mssql disable foreign key constraint
SQL
1 vote213 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote264 views1 answer
Mysql remove last character
SQL
5 votes238 views1 answer
Oracle add time to date
SQL
0 vote199 views1 answer
Show create table in postgresql
SQL
10 votes188 views2 answers
Linux command line import mysql database
SQL
0 vote227 views1 answer
Oracle grant create job
SQL
0 vote232 views1 answer
Sql basic commands
SQL
0 vote193 views1 answer
Select value from previous row in postgresql
SQL
-1 vote261 views1 answer
MYSQL stored procedure select from
SQL