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

-1 vote185 views1 answer
Module operator in oracle sql
SQL
1 vote205 views3 answers
Alter schema sql server
SQL
7 votes191 views1 answer
Sql pagination oracle
SQL
3 votes189 views1 answer
Mysql replace string in table
SQL
-1 vote155 views1 answer
Plsql while
SQL
3 votes159 views2 answers
Postgres download
SQL
0 vote198 views1 answer
Error code 1451 sql
SQL
0 vote166 views1 answer
Sql datediff db2
SQL
0 vote175 views1 answer
How to display value of variable in mysql
SQL
1 vote159 views1 answer
Import local sql into remote mysql
SQL