select substr(column_name,1,8) from table_name