querying db

[Anon]

I am querying a database to display a field in all rows. Is there a way to omit rows that contain empty fields?

[rrijnders]

SELECT myField FROM myTable WHERE myField<>''

[Anon]

cool, thanks!