Re: Question about views

Hi,

this works, but it's not a fine way:

create view xyz (name,age) as
select 'Y','Y' from table where name is not null and length(name) > 0 and age is not null and age !=0
union
select 'N','N' from table where (name is null or length(name) = 0) and (age is null or age=0)
union
select 'Y','N' from table where name is not null and length(name) > 0 and (age is null or age=0)
union
select 'N','Y' from table where (name is null or length(name)=0) and age is not null and age !=0;

Maybe I find a better way tonight ....
Greetings
Josh

Raymond Du wrote:

> I have a table
>
> Thanks
>
> Raymond Du
> IDM Corp.
Received on Tue Jun 23 1998 - 00:00:00 CDT