Replace an SQL statement with carriage return or line feed in the field

Cancel or replace the carriage return line break to keep the data clean. -- replace the carriage return UPDATEtable_nameSETfield_nameREPLACE (field_name, CHR (13),) WHEREINSTR (field_name, CHR (13) 0 -- replace the line feed Handler, CHR (10),) WHEREINSTR (field_name, CHR (

Cancel or REPLACE the carriage return/line feed to keep the data clean. -- REPLACE the carriage return UPDATE table_nameSET field_name = REPLACE (field_name, CHR (13), '') where instr (field_name, CHR (13 )) 0 -- REPLACE the newline UPDATE table_nameSET field_name = REPLACE (field_name, CHR (10), '') where instr (field_name, CHR (

Cancel or replace carriage return/line feed to keep data clean <无>

-- REPLACE press enter update table_nameSET field_name = REPLACE (field_name, CHR (13), '') where instr (field_name, CHR (13)> 0 -- REPLACE the newline UPDATE table_nameSET field_name = REPLACE (field_name, CHR (10), '') where instr (field_name, CHR (10)> 0 table_name: Table Name field_name: column name