retrieve empty row from database

[vinny199]

hi,

I'm trying to retieve all the rows in my table product_data where the column pd30 has no value inputed (Nul)

I cannot syntax my recordset properly. Should I use !empty to locate the nul values or something else.

here is where I'm at (I know this is wrong and doesnt work, but it gives the idea of what I'm trying to do):

SELECT * FROM product_data WHERE product_data.pd30 = !empty

Could you pls guide me to fixing this?

Cheers,

Vinny

[dougal85]

SELECT * FROM product_data WHERE product_data.pd30 IS NULL

Just for the sake of reference, if you want fields that are not empty, so "IS NOT NULL"

[vinny199]

why making it more complicated than it should, he?
thanks for that.
Vinny