how to select only first 3 characters in sql 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: sql server substring
SELECT SUBSTRING('SQL Tutorial', 1, 3) AS ExtractString;
Example 3: grab part of a string sql
SELECT SUBSTRING('SQLTutorial.org');