Sql substring

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

Grab part of a string sql

SELECT SUBSTRING('SQLTutorial.org');

Source: sqltutorial.org

Sql substring

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

Similar codes

0 vote190 views1 answer
Longtext sql
SQL
0 vote213 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote266 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote319 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote219 views1 answer
Sql query wordpress export post
SQL
4 votes196 views1 answer
Oracle show error line number
SQL
1 vote205 views1 answer
Mysql show data from table
SQL
1 vote188 views1 answer
Oracle get current schema
SQL
0 vote190 views1 answer
Mysql add comment to column
SQL
0 vote216 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL