title: Replace enter with space
body: <p>How can i replace "Enter" in one of fields in the database with space </p>
  
  <p>actually I have tried the below codes in vb.net, but non of them is working for me ,, </p>
  
  <pre><code> address = Replace(address, System.Environment.NewLine, " ")
  </code></pre>
  
  <p>or </p>
  
  <pre><code>address = Replace(address, vbNewLine, " ")
  </code></pre>
  
  <p>or </p>
  
  <pre><code>address = Replace(address, Chr(13), "")
  </code></pre>
  
  <p>Language : Vb.net 
  database : MSSQL 2005</p>
  
  <p>Thanks in advance </p>