Re: Urgent Empty Field

Eric,

Try this :

('" & value &"' <> '' and no_app = '" & value & "') or ('" & value &"' = '' and no_app is null)"

quotes might be a little off but you get the picture.... the optimizer will do the rest of the job.

Salut et bonne journee,

Marc Mazerolle
InforMaze Inc.

Eric Caron wrote:

> Here's my problem, in my database, I have field with NULL value and I must
> compare these fields with empty value like this :
>
> no_app='" & value & "'"
>
> This return no row, I try NVL(no_app,'')='" & value & "'" and this don't
> work too
>
> Do you have a solution thanks
>
> --
> Eric Caron
> Programmeur-analyste
> PG Systèmes d'Information
> 217 Léonidas
> Rimouski, QC
> Canada
> http://www.pgsystem.com
Received on Mon Dec 13 1999 - 13:49:28 CST