Hi there UDers,

All I wanna do is SELECT from a recordset WHERE MyFieldName is blank !

I tried " <> Yes "
I tried " = "" "
... but it ends up in me grgrgrrrommling...
What should I do ? |-(

e_site

Try this:

SELECT *
FROM YourTable
WHERE YourTable.MyFieldNane IS Null


Regards

Owen.


Edited by - oeastwick on 08/17/2001 02:48:10

All right oeastwick !!

thanx very much
e_site