pavankjadda/Remove line break or new line from column in SQL Server.md

Last active July 9, 2021 18:02

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/pavankjadda/9c246fcbf8be599b02a7fdd96906a24d.js"></script>
Save pavankjadda/9c246fcbf8be599b02a7fdd96906a24d to your computer and use it in GitHub Desktop.

Remove line break or new line from column in SQL Server

Raw

Use the followng query to replace line break or new lines from column in SQL Server.

Replace <TABLE_NAME> and <COLUMN_NAME> place holders with actual values

update <TABLE_NAME> set <COLUMN_NAME>=Replace(Replace(<COLUMN_NAME>,CHAR(10),''),CHAR(13),'');