0 - 1 of 1 tags for strings
String Functions

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. 

By cloud36, 13 May 2014 | Tagged: substring instr strings sql | 3 comments