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
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
© 版权声明
文章版权归作者所有,未经允许请勿转载。