SELECT
ISNULL(yourtable.ColumnA,ISNULL(yourTable.ColumnB,'BOTH ARE NULL')) AS ColumnA
FROMyourTable
But there is a function called isdbnull you could probably use.
Good Luck