title: Convert NULL to empty string in SQL Server
body: <p><img src="https://i.stack.imgur.com/QPhg2.png" alt="enter image description here"></p>
  
  <p>I'm getting Null values for 'AltReimMethod', which I want to convert to empty string values. Here's the query : </p>
  
  <pre><code>(SELECT rc.name from ReimbursementChoice rc WHERE rc.admin_id = a.admin_id AND rc.choice_id = pe.alt_payment_choice) AS 'AltReimMethod'
  </code></pre>
  
  <p>I tried </p>
  
  <pre><code>(SELECT (ISNULL(rc.name,' ')) from ReimbursementChoice rc WHERE rc.admin_id = a.admin_id AND rc.choice_id = pe.alt_payment_choice) AS 'AltReimMethod'
  </code></pre>
  
  <p>And also </p>
  
  <pre><code>(SELECT (ISNULL(CONVERT(varchar(50),rc.name),' ')) from ReimbursementChoice rc WHERE rc.admin_id = a.admin_id AND rc.choice_id = pe.alt_payment_choice) AS 'AltReimMethod'
  </code></pre>
  
  <p>They don't show any errors but I don't even get any results.</p>