find the data holding column

hi all,

in my table more than 5 columns are there.now i want to show

if column5 has data then show that column with the alias name as "Output"

else if column4 has data then show that column with the alias name as "Output"

else if column3 has data then show that column with the alias name as "Output"

else show column2

how to write the sql query for the above condition

Re: find the data holding column

SELECT COALESCE(column5, column4, column3, column2) AS Output
FROM MyTable

Re: find the data holding column

FINALLY I RESOLVED IT BY

SELECT CASE
    WHEN COL4 <> '' THEN COL4
    WHEN COL3 <> '' THEN COL3
    WHEN COL2 <> '' THEN COL2
    WHEN COL1 <> '' THEN COL1
END AS OUTPUT FROM MYTABLE;