<div>
&quot;replace&quot; is a reserved word in Sybase T-SQL. Try exactly the same syntax, just call it str_replace instead:<br />
<br />
&nbsp; &nbsp; &nbsp;select str_replace(&lt;column name&gt;,chr(10),'') from dbo.&lt;table name&gt;
</div>


"replace" is a reserved word in Sybase T-SQL. Try exactly the same syntax, just call it str_replace instead:

     select str_replace(<column name>,chr(10),'') from dbo.<table name>

<div>
Error: Function 'chr' not found.
</div>


<div>
Assuming you have only 1 linefeed per value, you can use stuff+charindex as replace function:<br />
<br />
declare @x char(35)<br />
select @x=&quot;Test&quot;+char(10)+&quot;String<wbr />&quot;<br />
select stuff(@x,charindex(char(10<wbr />),@x),1,'*<wbr />')<br />
<br />

</div>


Assuming you have only 1 linefeed per value, you can use stuff+charindex as replace function:

declare @x char(35)
select @x="Test"+char(10)+"String"
select stuff(@x,charindex(char(10),@x),1,'*')



<div>
the docs for sybase str_replace() can be found at <br />
<br />
<a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36271_1251/html/blocks/CJAEFCEG.htm" rel="ugc">http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36271_1251/html/blocks/CJAEFCEG.htm</a>
</div>


the docs for sybase str_replace() can be found at

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36271_1251/html/blocks/CJAEFCEG.htm [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc36271_1251/html/blocks/CJAEFCEG.htm]

<div>
<div class="content wysiwyg-content">
select replace(&lt;column name&gt;,chr(10),'') from dbo.&lt;table name&gt;<br />
<br />
The query above does not work, &quot;Incorrect syntax near keyword, 'replace'<br />
<br />
I'm unable to import the row because the column data contains line feed.
</div>
</div>


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.

In T-SQL Sybase, how will you replace linefeed, chr(10), with space while querying from a table column?

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.

Unix OS

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.