Re: Conditional on Select List

["Douglas McNaught" <doug@xxxxxxxxxxxx>]

On Tue, May 13, 2008 at 11:52 AM, Fernando <fernando@xxxxxxxxxx> wrote:
>
>  Is it possible to do this?
>
>  SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;

You should be able to use CASE for this.

-Doug