I have an oracle database that I am retrieving data with Access. One of the columns I am retrieving can be null. I need to interogate the column for certain values. However, I need to convert the nulls to some value so they are included in the comparision.
In SQL, this is what I want to do:
select PROD_ID from table1 where nvl(PROD_ID,'00') not in ('08','09')
How can I do this in Access?