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

0 vote330 views1 answer
Oracle running queries sql
SQL
1 vote347 views1 answer
Pgsql sum switch case
SQL
5 votes296 views1 answer
Mongodb vs
SQL
3 votes345 views1 answer
Oracle failed login attempts
SQL
7 votes306 views4 answers
How to reset the identity column in sql server
SQL
0 vote302 views1 answer
How to count null values in sql
SQL
13 votes303 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
5 votes344 views1 answer
Oracle nls instance
SQL
0 vote334 views2 answers
Identity column in sql server
SQL
0 vote370 views1 answer
How to set up an anonymous function to variable in swift
SQL