Re: id <> '2'

"mike" <hillmw_at_charter.net> wrote in message news:1127339848.337032.301560_at_z14g2000cwz.googlegroups.com...
>I guess I could use a join like:
>
> select *
> from mytable
> where id<>'2'
> union
> select *
> from mytable
> where id is null
>
> Any other ideas?
>

see my other post re: NVL()
or you could us an OR instead of UNION

++ mcs Received on Wed Sep 21 2005 - 17:03:51 CDT