Paul,
Sorry for the delayed reply.
Thanks for the gently reply.

Ciao
Tony.

> Views are selectable, just like tables. Instead of putting the where
> clause in the view why not add the where clause to the select that

calls

> the view?
>
> select * from myview
> where viewcol= :param
>
>
>
> Paul
>
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> taking InterBase further