Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    9

    Unanswered: Exits a function INFORMIX SE like ISNULL

    Is there any function, or a method wich is like ISNULL of MS-SQL.
    I need that the result of a SELECT does not contain a NULL value.
    Something like this:

    Select Isnull(cod,' ') As Cod from mytable

    Thanks a lot
    Tabacaru Teodor
    Ragusa,Italy

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    You can specify this in the where clause:
    select blah
    from table
    where blah is not null;
    rws

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Informix has an NVL function that is able to do the following:

    SELECT name, NVL(address, "address is unknown")
    FROM student

    In your case it would be:

    Select NVL(cod,' ') As Cod
    from mytable
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •