Choosing to select a column based on null values

[lachlanpearce]

Hi,
I have a table with these values:

=========================================
column1        column2        column3
firstname      462            david
lastname       smith          NULL
=========================================

I want to write a select query that will select either column2 or column3 based on whether column 3 is not null and output something like this:

=========================================
column1        column2
firstname      dave
lastname       smith
=========================================

So, if column3 is not null, select that column as column2, otherwise select column2.

Is this even possible?

[ck9663]

Yes, use the ISNULl() function.

Happy Coding!!!


~~ CK