blob: 4ef767b60f6ff2ee063f1f43a061daea6cc71c7e [file] [log] [blame]
SELECT id FROM (VALUES(''),('asdfkjhasdjkhgavdjhkgdvkjhg'),('aaaaa'),(''),('zzzzzzz'),('a'),('z'),('non-null-value')) tbl(id) WHERE NULLIF(id,'') IS NOT NULL;