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

13 votes259 views4 answers
What is sql
SQL
19 votes251 views6 answers
Mysql if null
SQL
11 votes242 views1 answer
Sql query to find duplicates in column
SQL
33 votes233 views2 answers
Postgres how to add field created at
SQL
1 vote246 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote249 views1 answer
SQL SERVER xquery count child nodes
SQL
-1 vote255 views1 answer
Add 10 to all numbers in a column sql
SQL
2 votes241 views1 answer
Mysql trigger after update
SQL
11 votes300 views2 answers
Import mysql dump command line windows
SQL
0 vote221 views1 answer
Postgresql remove duplicate rows 2 columns
SQL