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)