create table tb(col1 int,col2 int,col3 int)
insert into tb
select null,null,1 union all
select null,2,1
go

select coalesce(col1,col2,col3) col
from tb

drop table tb


/************************

col
-----------
1
2

(2 行受影响)