how to check the first character of a string in sql code example

Example: get first 2 letter in sql

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