sql 实现将空白值替换为其他值（sql把空值替换成0）这样也行？


select (CASE when (TelPhone IS NULL OR TelPhone=”) then ‘暂无’ else TelPhone end) as TelPhone,(CASE when (Name is null or Name=”) then ‘暂无’ else Name end) as name,(CASE when (CreateDate IS NULL OR CreateDate=”) then ‘暂无’ else CreateDate end) as CreateDate,(CASE when ([Address] IS NULL OR [Address]=”) then ‘暂无’ else [Address] end) as [Address] from User_Detail