title: SQL working strange
body: <p>When I execute this SQL code:</p>
  
  <pre><code>select id, opis, vidrabota, tipprov, hitnost, valuta, drzava, zbirnaprov, tip_zbirprov, kanal
  from dev_1450autoebanktip
  where opis is null or Opis like case when isnull('','') = '' then Opis else '%' + '' + '%' end
  and VidRabota = case when isnull('','') = '' then VidRabota else '' end
  and TipProv = case when isnull(0,0) = 0 then TipProv else 0 end
  and Valuta = case when isnull('','') = '' then Valuta else '' end
  and drzava is null or Drzava = case when isnull('','') = '' then Drzava else '' end
  </code></pre>
  
  <p>I get this set of results:
  <a href="https://i.stack.imgur.com/1S9wC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1S9wC.png" alt="enter image description here"></a></p>
  
  <p>But when I add one more condition (last row):</p>
  
  <pre><code>select id, opis, vidrabota, tipprov, hitnost, valuta, drzava, zbirnaprov, tip_zbirprov, kanal
  from dev_1450autoebanktip
  where opis is null or Opis like case when isnull('','') = '' then Opis else '%' + '' + '%' end
  and VidRabota = case when isnull('','') = '' then VidRabota else '' end
  and TipProv = case when isnull(0,0) = 0 then TipProv else 0 end
  and Valuta = case when isnull('','') = '' then Valuta else '' end
  and drzava is null or Drzava = case when isnull('','') = '' then Drzava else '' end
  and KANAL = case when isnull(0,0) = 0 then KANAL else 0 end
  </code></pre>
  
  <p>I am losing one row in the result. What is causing this change?</p>
  
  <p><a href="https://i.stack.imgur.com/ZEVjb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZEVjb.png" alt="enter image description here"></a></p>