IMG-LOGO

How to replace break line in TSQL?

andy - 08 Aug, 2014 4664 Views 0 Comment

To replace a break line is pretty simple, The Carriage return is represented by CHAR(13), while the Line Feed is represented by CHAR(10). You can use the following example replace method to do it.

REPLACE(REPLACE(REPLACE(FIELD_VALUE, CHAR(13) + CHAR(10), 'something else'), CHAR(13), 'REPLACE_VALUE'), CHAR(10), 'REPLACE_VALUE')
Note: The FIELD_VALUE is the original value that you want to replace with, this is usually the column field. while the REPLACE_VALUE is the value that you want to replace with.

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.

Related Articles

How to restore database using SQL query in TSQL?

If you have a database backup bak file extension and want to restore it using SQL query You can use the built in RESTORE DATABASE function Remember in order to be able to restore a database successfully You need to ...

How to get all table sizes in TSQL?

To get the information about how much space or size used by tables You can retrieve the size information by linking multiple tables in sys tables There are two tables that hold this information The first one is the sys ...