(T-Sql) NULL population 1

[markajem]

The code below works fine if sopnumbe is null it then uses order_num and populates master_sop_num with order_num. But I am also trying to achieve the reverse. If order_num is null then use sopnumbe and populate master_sop_num. I am not too go with syntax.

Thanks, much appreciated.

select
	case
	when sopnumbe is null
	then cast(order_num as char(21))
	else sopnumbe
	end as master_SOP_Num,

 

[gmmastros]

Select Coalesce(sopnumbe, order_num) As master_SOP_Num

Lookup the coalesce function in Books On Line.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[markajem]

That did it George. I will look it up.

Thanks for your help.