xxxxxxxxxx
Select SUBSTRING(StudentName,1,5) as studentname from student
xxxxxxxxxx
SELECT FIRST_NAME , SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;
xxxxxxxxxx
SELECT COUNTRY, SUBSTRING(Country, 1, 3) AS [Country first 3 letters] FROM CUSTOMER