Devart Forums

How can show all [Not] Empty values in a Column ?

Somthing Like : = Nil or IS NIL

and otherwise : <> Nil or is not Nil

Realy ?
Nobody ?

Isn't it the most usefull filter Expression at all ?

or is it so easy that noboby had a similar problem ?

Hi,
To show all rows with existing column values, you can use the following filter entry: "[field] = NULL" (or "[field] IS NULL"), and to show rows with empty values: [field] <> NULL" (or "[field] IS NOT NULL")