Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |