title: Does sqlite support any kind of IF(condition) statement in a select
body: <p>Does sqlite support the sql function "if" in the select statement? </p>
  
  <p>for example </p>
  
  <pre><code>select if( length( a ) &gt; 4 , a , ' ') as b
  from foo
  </code></pre>
  
  <p>which would return a if the length was over 4 chars long. or else it would return ' ' as b</p>
  
  <p>If it does support a condition in the select what is the syntax is should be using?</p>
  
  <p>I have checked  <a href="http://sqlite.org/lang_corefunc.html">http://sqlite.org/lang_corefunc.html</a> but I can't see it.</p>