Remove new line in column values in SQL Server
declare @NewLine char(2)
set @NewLine=char(13)+char(10)
UPDATE TableName
SET ColumnName=Replace(ColumnName, @NewLine,'')
WHERE ColumnName like '%' +@NewLine +'%'
declare @NewLine char(2)
set @NewLine=char(13)+char(10)
UPDATE TableName
SET ColumnName=Replace(ColumnName, @NewLine,'')
WHERE ColumnName like '%' +@NewLine +'%'
No comments:
Post a Comment