Re: Replace a null with 0 in query results?

From: tojo <Tojo_at_hotmail.com>
Date: Tue, 5 Aug 2003 11:24:57 +0200
Message-ID: <MPG.199996586026408d98969c@news.t-online.de>

In article <6189f70e.0308050122.597fc7c3_at_posting.google.com>, busch_at_twinoffice.net says...
> Hi
>
> I'm just writing a query and was wondering if it was possible to
> replace a null that I pull out with a specified value so that I can do
> some math functions.
>
> Thanks
>
> Des
>

Lookup the NVL function in the docs - that should do it.

Received on Tue Aug 05 2003 - 04:24:57 CDT

This message: [ Message body ]
Next message: Billy Verreynne: "Re: How to optimize this query?"
Previous message: Juicy Chunks of Goodness: "Replace a null with 0 in query results?"
In reply to: Juicy Chunks of Goodness: "Replace a null with 0 in query results?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US