Subject | Re: using case, coalesce... in fb 1.5 views |
---|---|
Author | matej1602 |
Post date | 2003-07-30T10:21:51Z |
> CREATE VIEW my_view (MYFIELD)Thanks. It works fine...
> AS
> SELECT
> (CASE WHEN b is null
> THEn 2
> ELSE 0
> END)
> FROM a
Matej
Subject | Re: using case, coalesce... in fb 1.5 views |
---|---|
Author | matej1602 |
Post date | 2003-07-30T10:21:51Z |
> CREATE VIEW my_view (MYFIELD)Thanks. It works fine...
> AS
> SELECT
> (CASE WHEN b is null
> THEn 2
> ELSE 0
> END)
> FROM a