title: SQL Case always uses first Case?
body: <p>So i have a SQl-Case where it asks if a integer % 3600 is over 10 or not... If not it should
  concat() a '0' in Front of it... Same as the other cases, which are slighlty changed... it should represent a time,</p>
  <p>It should result in somehting like this:<br></p>
  <p>Int_Sek<br>
  00:43:23<br>
  09:03:45<br>
  34:03:09<br></p>
  <p>But it ends like this:<br>
  Int_Sek<br>
  0:43:23<br>
  4:3:45<br>
  23:3:9<br></p>
  <p>So it always uses the first case and i don't know why... Anyone an idea?</p>
  <pre><code>Select concat(
  case 
  when Int_Sek / 3600 &lt;= 9 then concat('0', floor(Int_Sek / 3600)) 
  when Int_Sek / 3600 &gt;= 10 then floor(Int_Sek / 3600) END, ':', 
  case 
  when (Int_Sek % 3600) / 60 &lt;= 9 then concat ('0', (Int_Sek % 3600) / 60) 
  when (Int_Sek % 3600) / 60 &gt;= 10 then floor((Int_Sek % 3600) / 60) END, ':', 
  case 
  when ((Int_Sek % 3600) % 60) % 60 &lt;= 9 then concat('0', ((Int_Sek % 3600) % 60) % 60) 
  when ((Int_Sek % 3600) % 60 )% 60 &gt;= 10 then floor(((Int_Sek % 3600) % 60) % 60) END) as &quot;Column A&quot;,
  from Table A
  </code></pre>