Replace a newline character in a SQL field, carriage return

Sometimes we need to replace some unwanted SQL fields, and here are a few things you can do to replace SQL fields, if you're interested in replacing SQL fields.

Replace the line break in the SQL field with a carriage return:

1> Carriage return character

SELECT *, replace (detail, CHAR (+), ' <br> ') as displays the replaced content from Loginfo

2> line break

SELECT *, replace (detail, CHAR (Ten), ' <br> ') as displays the replaced content from Loginfo

3> Return line break

SELECT *, replace (detail, char (+) + char (Ten), ' <br> ') as displays the replaced content from Loginfo

4> Replace carriage return line break to <BR><BR>

UPDATE Loginfo
SET detail = REPLACE (detail, char) + char (Ten), ' <br><br> ')

Note In the DOS \win series there will be a carriage return + newline character CHAR (10) +char

In UNIX \ Linux is a line break

Convert just remove the carriage return char (13).

The following SQL statement

UPDATE loginfo SET detail = REPLACE (detail, CHAR (13), ")

Replace a newline character in a SQL field, carriage return