--- 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