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 vote338 views5 answers
Left join
SQL
1 vote342 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
20 votes322 views5 answers
Sql show tables
SQL
0 vote325 views1 answer
Mysql loop through databases and execute query
SQL
0 vote316 views1 answer
Alter owner in PostgreSQL
SQL
2 votes271 views1 answer
Oracle current date without time
SQL
0 vote292 views1 answer
Generate sequence number in sql server
SQL
0 vote330 views1 answer
Product of a column in mysql
SQL
0 vote307 views4 answers
Mysql select bottom 10 rows
SQL
3 votes302 views3 answers
Mysql get table size
SQL