On Sun, 29 Feb 2004 19:55:15 -0500
Bill Moran <wmoran@potentialtech.com> wrote:
> Not really sure I understand what you want, but try something like this:
>
> select case when count(*) > 0 then ''t'' else ''f'' end from ...
Unfortunately that does not work. When the resultset contains no records
whatsoever, I get no rows at all - so on case...else sort of expression within
the select itself will work.
What I am looking for is a way to select "0" if no rows are returned, or the
total number of rows returned from the query otherwise.
Thanks anyways though.
Ciao
Zak
--
========================================================================
http://www.carfolio.com/ Searchable database of 10 000+ car specs
========================================================================