I tried to use case (and coalesce) function in view, but I get error
(token unknown). Is it possible to use functions like case in views
(it works fine in "normal" select)?

Thanks for answer.

Matej

p.s. I use Firebird 1.5, RC 4.