I tried to use `REPLACE` to delete some words, like 'HOMEMAKER' and 'HOUSEWIFE', from strings. But I failed to change those words into empty space. Why is that happening?

I want to delete strings like '*HOMEMAKER*' and '*HOUSEWIFE*' from column EMPLOYER using `REPLACE` function but failed. I also tried REGEXP\_REPLACE but failed again. These are the table I have (Sorry I want to build a table here but somehow it doesn't work).

> 
> EMPLOYER  
> 
>  RETIRED/HOMEMAKER  
> 
>  HOMEMAKER/HOMEMAKER  
> 
>  SELF-EMPLOYED/HOMEMAKER
> 
> 
> 

We code is listed below:

```
SELECT EMPLOYER,
       CASE WHEN EMPLOYER LIKE '%HOUSE%WIFE%'
            THEN REGEXP_REPLACE(EMPLOYER,r'HOUSE%WIFE',' ')
            WHEN EMPLOYER LIKE '%HOME%MAKER%'
            THEN REGEXP_REPLACE(EMPLOYER, r'HOME%MAKER', ' ')
            ELSE '0'
            END AS SIGN
FROM fec.work
WHERE EMPLOYER LIKE '%HOME%MAKER%' 
OR EMPLOYER LIKE '%HOUSE%WIFE%'
GROUP BY 1,2;

```

The result I want is like:

> 
> SIGN  
> 
>  RETIRED/  
> 
>  /  
> 
>  SELF-EMPLOYED/
> 
> 
> 

But I got exactly the same columns in `SIGN` as `EMPLOYER`. Can anyone tell me why `replace` function did not make any changes?