Re: Procedure

From: Helmut Hahn <hahn_at_livinglogic.de>
Date: Tue, 18 Jun 2002 09:24:23 +0200
Message-ID: <3D0EE027.9090600@livinglogic.de>

Hi,

try NVL(Field,value if Field is NULL)

Stefan Eckleder wrote:

> Hi,
>
> I need a Procedure, who can check in a SELECT Statement which entry in a
> field is NULL. The Procedure must check numeric/alphanumeric too.
>
> SELECT * FROM test.
>
> check all fields numeric or alphanumeric and NULL
> when numeric write 0, when alphanumeric write 'nothing'
>
> thanks
> Stefan
>
>
Received on Tue Jun 18 2002 - 02:24:23 CDT