sql db2 how to string match between two columns : Hi if I have two columns such as:

    col1                                 col2
    ----                                 ----
    5qt                                  exception for 5qt ammended
    5qt                                  exception for 5076 ammended
    6d3                                  6d3 registered

I want to string match so that if the value of `col1` exists in `col2`, return col2.

So I get:

    exception for 5qt ammended
    6d3 registered

I have tried using `locate()` but not with much luck:

    select col2 from mytable
    where locate(col1,col2) = 1

I have previously had this working where `col2` began with the value of `col1` i.e.

    col1                                 col2
    ----                                 ----
    5qt                                  5qt ammended
    5qt                                  5076 ammended
    6d3                                  6d3 registered

but it seems the fact the value of `col1` can appear in any position of `col2` is throwing `locate()` off the trail. 

any advice would be grateful.