Discussion Locked
IF in SQL Select Statement
0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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