get first 3 letters in sql
SELECT FIRST_NAME , SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME) FROM EMPLOYEES ;
sql server substring
SELECT SUBSTRING('SQL Tutorial', 1, 3) AS ExtractString;
grab part of a string sql
SELECT SUBSTRING('SQLTutorial.org');
Source: www.sqltutorial.org
how to select only first 3 characters in sql
SELECT COUNTRY, SUBSTRING(Country, 1, 3) AS [Country first 3 letters] FROM CUSTOMER