sql return first n characters code example

Example 1: get first 3 letters in sql

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

Example 2: how to fetch first 5 characters in sql

Select SUBSTRING(StudentName,1,5) as studentname from student