--Thanks all (esp. doug, peter, stephan)
--works like a charm!
-X
-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
On Tue, 4 Jun 2002, Johnson, Shaunn wrote:
> Howdy:
>
> I want to know if this is even possible: How
> can I return a true/false value instead of
> integer?
>
> I want to do something like this:
>
> [snip]
>
> select count(*) from t_table
> having count(*) > 1500000
>
> [/snip]
>
> But want to return a true/false (bool) result.
Wouldn't select count(*)>1500000 from t_table;
give you a true/false based on whether the count
is greater than that number?