SELECT SUBSTR(COL1, 0, 3) FROM TABLENAME;