title: An expression of non-boolean type specified in a context where a condition is expected, near 'END'
body: <p>So maybe someone can point me in the right direction of what is causing this error?  I've been fighting with this for a couple of hours and searching the web, and I can't figure out what I'm doing wrong here.  It's included as part of a stored procedure, I don't know if that matters, if it does I can include that as well.  Tables and field names have been changed to protect the innocent... meaning my job.  Thanks.</p>
  
  <pre><code>SELECT
                /* The fields are here*/
  FROM
                /* my joins are here */
  WHERE
      (Table.Field = stuff)
      AND
      (Table.Field2 = otherstuff)
      AND
      (Table2.Field3 = someotherstuff)
      AND
      CASE @param1
          WHEN 0 THEN 'Table.Field IS NULL'
          WHEN 1 THEN 'Table.Field2 IS NOT NULL'
          ELSE ''
      END
  </code></pre>
  
  <p><strong>Thanks for the responses.  Technically egrunin was the correct answer for this question, but OMG Ponies and Mark Byers were pretty much the same thing just missing that last piece. Thanks again.</strong></p>