Is there a way to construct a select statement that will insert one of two different columns depending on the value in one of those columns? For example, in a single output column, for each record I want to show the value from column A unless it is Null. If column A is Null, I want to show the value from column B. Is this possible?
Thanks
Greg
