Find empty fields

code green

How can empty fields be detected.

Expand|Select|Wrap|Line Numbers

 SELECT * FROM products WHERE 

description IS EMPTY

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

Delerna

Expand|Select|Wrap|Line Numbers

 
SELECT * 

FROM products 

WHERE  description IS null OR rtrim(description)=''

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(description))=''

ck9663

also...

Expand|Select|Wrap|Line Numbers

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

code green

Expand|Select|Wrap|Line Numbers

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

Find empty fields

re: Find empty fields

re: Find empty fields

re: Find empty fields

re: Find empty fields

re: Find empty fields

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about