Question: This is the code I have.

```
SELECT CustNum, IFNULL(CustRep, 'None') AS CustRep
FROM Customers;

```

The Error I am getting is

> 
> ORA-00904: "IFNULL": invalid identifier
>  00904. 00000 - "%s: invalid identifier"
>  \*Cause:  
> 
>  \*Action:
>  Error at Line: 11 Column: 8
> 
> 
> 

I understand the issue is with the IFNULL but I am unsure why.

Answer: 
I am not sure about `IFNULL` but you can use `NVL` in your scenario :

```
SELECT CustNum, NVL(CustRep, 'None') AS CustRep
FROM Customers;

```
I think you want `COALESCE()`:

```
SELECT CustNum, COALESCE(CustRep, 'None') AS CustRep
FROM Customers;

```