Use decode.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
Raymond Du <rdu_at_idmcorp.com> wrote in article
<6mmh79$qfd_at_nntp02.primenet.com>...
> 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 Wed Jun 24 1998 - 00:00:00 CDT
