On Tue, May 13, 2008 at 11:52 AM, Fernando <fernando(at)ggtours(dot)ca> 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