1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

DB2 - SQL Remove between a pattern

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

0
  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