declare @NewLine char(2)
set @NewLine=char(13)+char(10)
update StockSerialMaster
set StockSerialNo =Replace(StockSerialNo , @NewLine,'')
WHERE StockSerialNo like '%' +@NewLine +'%'
August 25, 2011
Remove new line from column in sql
Leave a Comment »
No comments yet.
RSS feed for comments on this post. TrackBack URI
