How about,

> > Show us the DDL statement of your view, and we might be
> > able to help.
> I create simple table:
> CREATE TABLE A
> (B INTEGER);
>
> Then I try with simple select with use of case, which work fine:
> SELECT
> (CASE WHEN b is null
> THEn 2
> ELSE 0
> END) as myfield
> FROM a
>
> Then I try same with view:

CREATE VIEW my_view (MYFIELD)
AS
SELECT
(CASE WHEN b is null
THEn 2
ELSE 0
END)
FROM a


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com