Are SQL statements IS NULL / IS NOT NULL supported in DESelect?

question are sql statements is null/ is not null supported in deselect? answer yes, they are represented as filtering options is empty and is not empty example you would like to have a list of contacts without emails this can be done by creating a filter for field email on the contacts data extension, and choosing filter is empty