Find empty fields

[code green]

How can empty fields be detected.

SELECT * FROM products WHERE 
description IS EMPTY

The field may be NULL
or just empty and I suppose even space characters.

[Delerna]

[code=sql]
SELECT *
FROM products
WHERE description IS null OR rtrim(descripti on)=''
[/code]

[code green]

Thanks Delerna
I figured as much, I do something similar in MySql.
Although I once had a regex that achieved this.

But it may need to be RTRIM(LTRIM(des cription))=''

[ck9663]

also...

WHERE isnull(rtrim(ltrim(description)),'') = ''

[code green]

WHERE isnull(rtrim(ltrim(description)),'') = ''

I like that ck9663, although I can't quite see how it works.
It looks like a COALESCE should be there

[code green]

Got it. isnull() function rather than IS NULL