I'm trying to replace a null column with 'N/A', and I know that it's a different data format, but this is what the client is asking for.
This is what I'm using: IFNULL(COLUMN, 'N/A')
This is what I get: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000]
[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message
returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59021] CASE
conditional expressions have mismatching data types. (HY000)
If I use a "0" instead of N/A it works. Is there a way to work around this?
It errors out in the RPD as well when I use this.