mssql case when else

參考來源:SQL Server: CASE WHEN OR THEN ELSE END => the OR is not supported
 --

case  when tel1='' or tel1 IS NULL then mob else tel1 end as tel

當tel1 空值或null , 使用手機取代值