DB2 - SQL Remove between a pattern

Discussion in 'Databases' started by flyguy, Sep 24, 2008.

  1. #1
    I have a field that contains html code and need it stripped out when I select it for exporting to a flat file.

    For instance: Field1 <b>Copy here</b> <br />More Copy here.

    I Want to use the pattern < to indicate the begining and > to indicate the end. Everything in between and including <> are to be removed.

    the result would be "Copy here More Copy here."

    Any thoughts?
    Mike
     
    flyguy, Sep 24, 2008 IP