I need help with this simple SQL

Database

I need help with this simple SQL

I am using CASE to get some row values froma large table and assigning the case value as a column. Now I am getting three columns like this which I dont want :

COL1 COL2 COL3
------------------------------------------------
VALUE1 NULL NULL

NULL VALUE2 NULL

NULL NULL VALUE3

Can't I merge these 3 columns and get one row which has all 3 values
?

Please any advice would be appreciated.
Thanks
1 REPLY

Re: I need help with this simple SQL

Yes...

Select max(col1)
,max(col2)
,max(col3)
from table /* or derived table in here */;