SQL update column with inner select via replace
===

I need to go throu a mssql db and remove a line out of the value.  What i wanted to do was something like this


    UPDATE infotabs
    SET [content] = 
        replace(
         replace(
            (
                SELECT [content] 
                FROM   infotabs AS ib
                WHERE  ib.infotab_id = i.infotab_id  
            ), '<p>', '')
        , '</p>', '')
    WHERE infotab_id= 
        (
            SELECT i.infotab_id 
            FROM         infotabs AS i
            WHERE     ([content] LIKE '%<p>%') 
        )


So basicly i need to loop thru the db and rmove all &lt;p&gt; and &lt;/p&gt; from the feilds.  can someone help me out here?

