0 - 1 of 1 tags for strings

I'm looking to split a string in Teradata.

 

The table might look something like this.

    

    column1
    hello:goodbye:afternoon

I'm trying to use SUBSTRING and INSTR to extract specific words.  So, say I want to select "goodbye". I'm trying the following query.