title: SQL Server : conditional case in where clause
body: <p>I would like to write the following as a <code>CASE</code> statement in my <code>WHERE</code> clause, but I'm unsure how to write it.</p>
  
  <pre><code>if @Result = '' then 
      [Result] = @Result
  else
      [Result] like @Result + '%'
  endif
  </code></pre>