Thank you, Dariuszs.<br><br>Where can I find documentation on this?  <a href="http://monetdb.cwi.nl/SQL/Documentation/Queries.html">http://monetdb.cwi.nl/SQL/Documentation/Queries.html</a> does not seem to indicate that CASE statements are allowed.<br>

<br>I was also wondering if I can designate aliases.  The conventional syntax below does not seem to work:<br><br>SELECT my_field [AS] f1 ...<br><br><div class="gmail_quote">On Fri, Apr 16, 2010 at 10:19 AM, dariuszs <span dir="ltr">&lt;<a href="mailto:dariuszs@svnp.com">dariuszs@svnp.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">select case when column1 is null then &#39;Absent&#39; else &#39;Present&#39; end from table1;<br>


<br>
Hering Cheng wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">
Hi,<br>
<br>
Is there any plan to add support for CASE in SELECT clauses to MonetDB?<br>
<br>
Thanks.<br>
Hering<br></div></div>
------------------------------------------------------------------------<br>
<br>
------------------------------------------------------------------------------<br>
Download Intel&amp;#174; Parallel Studio Eval<br>
Try the new software tools for yourself. Speed compiling, find bugs<br>
proactively, and fine-tune applications for parallel performance.<br>
See why Intel Parallel Studio got high marks during beta.<br>
<a href="http://p.sf.net/sfu/intel-sw-dev" target="_blank">http://p.sf.net/sfu/intel-sw-dev</a><br>
------------------------------------------------------------------------<br>
<br>
_______________________________________________<br>
MonetDB-users mailing list<br>
<a href="mailto:MonetDB-users@lists.sourceforge.net" target="_blank">MonetDB-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br>
  <br>
</blockquote>
<br>
<br>
<br>
</blockquote></div><br>