title: sql case statement error
body: <p>I have a case statement, however; I'm getting two erros. I can't seem to find the answer to the fix the errors.</p>
  
  <pre><code>SELECT #TMP.webid_Val = CASE #TMP.webid 
  when 'NULL' then 'NOT COMPLIANT'
  else 'COMPLIANT'
  end
  FROM #TMP
  </code></pre>
  
  <p>*<strong>*Incorrect syntax near FROM. Expecting CONVERSATION</strong></p>
  
  <p><strong>Incorrect syntax near =**</strong></p>
  
  <p><code>#TMP</code> is the temporary table. 
  webid is the value to be looked at for the condition
  webid_val is the column who's value will be changed. </p>
  
  <p>Any help would be appreciated.</p>