How to query for a column with white spaces only? 1

[lcs01]

A column with varchar type and NULL allowed. How do I write a sql so that I can retrieve the records with unknown number of white spaces only?

Thanks for your help.

 

[vacunita]

You mean empty values???

Select mycolumn from mytable where mycolumn=" ";

or NULL values:

Select mycolumn from mytable where mycolumn is NULL;


----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[r937]

this would be simpler --

WHERE COALESCE(daColumn,'') = ''

r937.com | rudy.ca

 

[lcs01]

Thank you, r937. That's the one I am looking for.

To vacunita, than you for your response. I am trying to query a column with 1+ white spaces only.