sql中替换换行符和空格的示例

select DiscussID,L.Name as LocationName , C.Name as ClientName, REPLACE(BrandName,' ','') BrandName ,ClientContactName,ClientContactPost,CooperationIntention+M.MasterDataName CooperationIntention,U.UserName DiscussPeople,CONVERT(nvarchar(20), DiscussDate,20) AS DiscussDate,
REPLACE(DiscussContent,'
',' ') DiscussContent from
 SG_Discuss D with(nolock)

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/heyiping/p/9723796.html