<div>
is this a linked server to db2 or what?
</div>


<div>
declare @CRLF varchar(2)<br />
set @CRLF = CHAR(13) + CHAR(10)<br />
<br />
select .... replace(ADDITIONAL_INFO,@C<wbr />RLF,'')<br />
from <br />

</div>


declare @CRLF varchar(2)
set @CRLF = CHAR(13) + CHAR(10)

select .... replace(ADDITIONAL_INFO,@CRLF,'')
from


<div>
<div class="content wysiwyg-content">
We'd like to remove the CR/LF from a single field called &quot;ADDITIONAL_INFO&quot;. &nbsp;The tricky part is, is that there may be one or more CR/LF within the data. &nbsp;After the CR/LF(s) are removed we need a space between the data. &nbsp;There may be CR/LF at the beginning and at the end of the field.<br />
<br />
For example, &quot;JOHN DOE &lt;cr/lf&gt; &lt;cr/lf&gt; AND JANE DOE &lt;cr/lf&gt;&quot; would become &quot;JOHN DOE AND JANE DOE&quot; as the field.<br />
<br />
PS: &nbsp;We are using SQL Server to connect to DB2 (if that matters).<br />
<br />
<br />
<br />

</div>
</div>


We'd like to remove the CR/LF from a single field called "ADDITIONAL_INFO".  The tricky part is, is that there may be one or more CR/LF within the data.  After the CR/LF(s) are removed we need a space between the data.  There may be CR/LF at the beginning and at the end of the field.

For example, "JOHN DOE <cr/lf> <cr/lf> AND JANE DOE <cr/lf>" would become "JOHN DOE AND JANE DOE" as the field.

PS:  We are using SQL Server to connect to DB2 (if that matters).





Removing one CR/ LF and/or multiple CR/LF from a single field

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.