Thanx David, this is also helpful.

And thanx to all that helped out with my dilemna.

cheers,
-randall

--- In firebird-support@yahoogroups.com, "David Richmond"
<firebirdfaq@...> wrote:

>
> --- Randall Sell wrote:
> > Can someone please tell me where this is wrong? And what the
> > correct SQL syntax should be? I'm trying to get my stord procedure
> > to return results from one of 2 views based on a condiiton.
>
> Take a look at:
>
> http://www.firebirdfaq.org/faq322/
> http://www.firebirdfaq.org/faq69/
>
> For explanation and examples.
>
> --
> David Richmond
> http://www.firebirdfaq.org
>