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

Show us the DDL statement of your view, and we might be
able to help.

--
Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com