Question about views

I have a table

name            age
====            ====
John                30
Mike                35
Albert              20
David              45


(NULL)           65


(SPACE)       56


Cathy              0
Gina                (NULL)

I want to build a view and return something like

name            age
====            ====
Y                     Y
Y                     Y
Y                     Y
Y                     Y
N                     Y
N                     Y
Y                     N
Y                     N

Thanks

Raymond Du
IDM Corp. Received on Mon Jun 22 1998 - 16:10:01 CDT