Urgent Empty Field

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 - 12:53:42 CST