특정 단어가 있으면 모든 줄에서 해당 단어를 제거하고 싶습니다.

예를 들어:

CREATE VIEW AIPKEYITEM.SEASONGROUPNETSALES ( 
CALENDARID , 
PRODUCTGROUPID FOR COLUMN PRDGRPID   , 
NETSALESDOLLARS FOR COLUMN NETSA00001 , 
NETSALESUNITS FOR COLUMN NETSA00002 ) 
AS 
SELECT  
        (SELECT MIN(CALENDARID)  
            FROM AIPKEYITEM.KEYIT00002  
            WHERE FISCALYEAR = CAL.FISCALYEAR  
            AND FISCALSEASON = CAL.FISCALSEASON) CALENDARID  
    , PRODUCTGROUPID  
    , SUM(NETSALESDOLLARS) NETSALESDOLLARS  
    , SUM(NETSALESUNITS) NETSALESUNITS  
    FROM AIPKEYITEM.KEYIT00002 CAL  
    INNER JOIN AIPKEYITEM.WEEKG00001 WEEKGROUPORGUNITUNITSDOLLARS  
    ON CAL.CALENDARID = WEEKGROUPORGUNITUNITSDOLLARS.CALENDARID  
    GROUP BY CAL.FISCALYEAR, CAL.FISCALSEASON, PRODUCTGROUPID ; 

위의 예에서는 FOR COLUMN이 있는 줄부터 전체 단어를 삭제하고 싶습니다.