Get first 3 letters in sql

-- 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

Get first 3 letters in sql

SELECT FIRST_NAME ,  SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;

Similar codes

0 vote139 views1 answer
Vbscript clean up ADODB.Recordset
SQL
10 votes117 views2 answers
Linux command line import mysql database
SQL
0 vote147 views1 answer
Delete a temporary table mysql
SQL
0 vote142 views1 answer
Executescalar in sql server
SQL
9 votes131 views5 answers
Sql limit
SQL
0 vote143 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
1 vote122 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
7 votes152 views3 answers
Sql server check if temp table exists
SQL
7 votes121 views1 answer
Sql server convert string to date
SQL
0 vote124 views1 answer
Get number of table colums in sql query
SQL