title: Specified cast is not Valid - bit value has NULL from stored procedure
body: <p>I use data from a stored procedure that returns two columns:  Paid and New</p>
  
  <p>They both contain bit values. So, it returns 0 or 1, but some test data return a NULL.</p>
  
  <pre><code>Paid  New
   1     1
   0     0
   1    NULL
  </code></pre>
  
  <p>As a result I am getting this error </p>
  
  <pre><code>Specified cast is not valid
  </code></pre>
  
  <p>How would I resolve this issue in c# or better yet in the stored procedure itself, so that the stored procedure would only return 0 or 1.</p>