Search code examples
sqlregexdatabasesap-ase

How to remove newline from column values in Sybase

i have a table in sybase that has 7 columns.

The sixth column has a new line as the last character in all the values. This newline is messing up the output when i export the table. How can i remove the newline character from all values in this column ?

Solution

  • this did the trick

    update tableName
set column_name =str_replace(column_name, char(13), null)