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

49 votes216 views6 answers
Alter table add column
SQL
6 votes132 views1 answer
Rank function in oracle with example
SQL
0 vote152 views1 answer
Ms sql filter all sympbol
SQL
0 vote136 views1 answer
Psql list rules
SQL
0 vote130 views1 answer
Mysql multiple count
SQL
0 vote130 views1 answer
Change default schema sql server
SQL
0 vote168 views1 answer
Drop all data from tables
SQL
4 votes139 views1 answer
Restart for pg_hba.conf file
SQL
2 votes161 views1 answer
Oracle apex who is connected
SQL
1 vote196 views1 answer
Insert column after column mysql
SQL