SQL Query Removing extra line CHAR(10) in string
<p>Hi I'm having a hard time to formulate replace for strings with line space or char (10)</p>

<p>test string</p>

<pre><code>"1st line string  char(10) char(10) 2nd line string  char(10) char(10) char(10) 3rd line string  char(10)"
</code></pre>

<p>expected result</p>

<pre><code>1st line string 
2nd line string 
3rd line string 
</code></pre>

<p>how to achieve this output?</p>