title: Delete empty lines in a text blob
body: <p>I have a list of email addresses in a table called cc_list (blob(text)). To remove an email address from the list, I have used the replace function</p>
  <pre class="lang-sql prettyprint-override"><code>update actions 
  set cc_list=replace(cc_list,'email@bob.com','') 
  where contact_id=85
  </code></pre>
  <p>Now, the list shows as</p>
  <pre><code>email
  email
  
  email
  email 
  </code></pre>
  <p>In the GUI, I just see the empty lines at the top. I have tried the trim option removing the carriage return (ascii_char(9))</p>
  <pre class="lang-sql prettyprint-override"><code>trim(leading from replace (cc_list, ascii_char(9),'')) 
  </code></pre>
  <p>and</p>
  <pre class="lang-sql prettyprint-override"><code>replace(cc_list,ascii_char(9),'') 
  </code></pre>
  <p>I still see the empty lines.</p>
  <p>What can I do to fix this?</p>