title: is there any `backspace` character in mssql for string?
body: <p>Below is the query to form a string containing company details by concatenating Name, address1 and address2. Here I am using the <code>ISNULL()</code> function to concatenate an empty string ('') if the column is null.  </p>
  
  <pre><code>select Name+' ,'+isnull(Address1,'')+' ,'+isnull(Address2,'') as compDeatils 
  from tableCompany where ID = 4
  </code></pre>
  
  <p>This query's issue is in the case where Address1 or Address2 is null, it will concatenate a comma before the empty space which I don't want. </p>
  
  <p>For example, if Address1 and Address2 are NULL then the result will be <code>name,,</code>. </p>
  
  <p>How i can overcome this? </p>
  
  <p><em>Is there a backspace character in mssql?</em></p>