In T-SQL Sybase, how will you replace linefeed, chr(10), with space while querying from a table column?
Posted on 2008-06-16
select replace(<column name>,chr(10),'') from dbo.<table name>
The query above does not work, "Incorrect syntax near keyword, 'replace'
I'm unable to import the row because the column data contains line feed.