select REGEXP_SUBSTR('ONE|TWO|THREE|FOUR|FIVE|SIX|SEVEN|EIGHT|NINE|TEN|ELEVENTHEBAND|TWELVE', '[[:alpha:]]+' , 1 , 3);