title: Replacing blank values with SQL in Sisense
body: <p>Anyone here familiar with Sisense?</p>
  
  <p>Within Sisense, I am writing a custom SQL query to return True/False based on a range of numerical values.   Several fields are blank, which is causing the <code>InRange</code> function not to work, as the range conditions can't be applied to null/blank values.</p>
  
  <p>I am trying to replace nulls with -999 so that the <code>InRange</code> function may apply.  I've tried <code>ISNULL</code> and <code>WHEN</code> statements to no avail.  These approaches should work in SQL but for some reason Sisense is returning errors.  Does anyone know how I would be able to populate this?</p>
  
  <p>Example Table:</p>
  
  <pre><code>State   |  Number of Reps
  NY             12
  NJ             36
  CT             NULL
  </code></pre>
  
  <p>Thanks!</p>