Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    42

    Unanswered: Replacing null values?

    Hello,

    I'm trying to simply trap and replace null values. I can't seem to find a function that would help me.

    Is there a function that would do something like the NVL in Oracle or the IsNull in SQL Server?

    Thanks.

    JFS

  2. #2
    Join Date
    Aug 2002
    Location
    St. Louis
    Posts
    16
    I'm not completely clear on what you're trying to accomplish but you might check into the Coalesce(x,y) function which returns the first non null argument or Null if both arguments are null. Coalesce and Value are the same functions.

Posting Permissions

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