I have table with text column and we can have empty values in that column. I want to filter data where column is not empty. How can we do this.
CREATE TABLE Test ( pk text, cck text, data text, PRIMARY KEY(pk,cck));
Select pk, cck from Test where pk='something' and data <> '' Allow Filtering