select DEPT_CODE, 
case when VALID_FLG = 1 then replace(DEPT_NAME , '課' , 'グループ') 
     when VALID_FLG = 0 then DEPT_NAME end as DEPT_NAME,
VALID_FLG from TBL_DEPT;