Re: to NULL OR NOT to NULL ? That is the Question.

Ian Harcourt (ianhar_at_u09002.skm09.svskt.se) wrote:

> Hi !
> I'm new to this group but I hope this is thew right forum to air my
> problem.
 

> I'm working with Oracle 6.0 and Forms 3.0. I have a problem with a
> SELECT statement.
 

> The table in question has a column that CAN contain a VALUE or NULL.
 

> I wish to incorporate into ONE select statement the possibility to select all
> posts OR just those posts with a certain value, i.e.

Try this:

   select col
   from table
   where

          col like in_parameter or
         (col                 is null and
          rtrim(in_parameter) is null )

--
**************************************************************
*                          Saad Ahmad                        *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************