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 vote181 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote193 views4 answers
Mysql replace regex
SQL
-1 vote180 views1 answer
Get id from just inserted row mysql server python
SQL
10 votes164 views2 answers
Sql merge statement
SQL
0 vote185 views1 answer
Turnicate in mysql
SQL
4 votes180 views2 answers
Oracle default date format
SQL
14 votes174 views2 answers
How to auto increment in sql
SQL
0 vote183 views1 answer
Sql max min
SQL
0 vote193 views1 answer
Mysql custom sort order
SQL
0 vote168 views1 answer
Mysql cdn link
SQL