Selecting non empty values

[ryanschefke]

Hello,

I have a table and some of the rows has an empty value in one of the columns. It is blank (in other words, it is not "NULL"). How do I only select the rows that have a value and are not empty. The SELECT WHERE value IS NOT NULL doesn't work, and I understand why since I am putting in blank values.

Thanks!

Ryan

[NogDog]

You could cover all bases with something like:

. . . WHERE (col_name NOT NULL AND col_name != '')