title: How to remove the spaces of a varchar value in sql server?
body: <p>I have a procedure which retrieves all the procedure scripts from a database defined.</p>
  
  <p>The problem  am getting is values with the blank spaces </p>
  
  <p>for exampl :</p>
  
  <p>when i executes the procedure i am getting the char(13) + char(10)'s (ie: Spaces between each print)</p>
  
  <pre><code>Print @IsSQl5 
  
  
  Print @IsSQl6                  
  
  
  Print @IsSQl7                  
  </code></pre>
  
  <p>I tried with replace function but it doesn't works fine How to solve this ?</p>