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 vote261 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
23 votes258 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote264 views1 answer
Mysql subdate
SQL
0 vote245 views1 answer
Show all mongodb
SQL
0 vote288 views1 answer
Get role postgres
SQL
0 vote280 views1 answer
Mysql get hour from datetime
SQL
9 votes259 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote287 views1 answer
Postgre query date
SQL
0 vote251 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote263 views1 answer
Oracle current timestamp insert statement
SQL