--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:

> Moreover, I don't quite follow when you say that you need a view for each possible combination, rather, I'd say you need a new column for each possible combination and that whether this additional field should be added to an existing view or a new view is something to investigate for each situation.

I would need a separate view for each combination because I was thinking of using a JOIN to restrict the rows returned rather than creating a computed column for the view and then just testing the value of the computed column. In fact, I didn't know that you could create computed columns on a view like that. Another way to accomplish the same goal.