I have a database were the tables that contain volatile data include codes which are used in joins to other tables that hold the description associated with that code.
There are instances in the volatile data where fields that contain codes are rightly empty.
In these instances I would like the query results to show a piece of text such as "None" or "N/A" but this is beyond my understanding of the software.
Can this be done and if so, how?
Thanks in advance.