Not Equal To when null fields exist.

Today I added DECEASED to my database fields so I can do a memorial section. The shortcoe is outside the loop, I use this –

$gradyear = substr ($post->post_name, -4)

– to get the grad year. I’m not having a problem filtering deceased=yes but I can’t get it to show a list of everyone except deceased.

do_shortcode('[pdb_list template="gradyear" orderby="last_name" order="asc" fields="photo, first_name, nickname, maden_name, last_name, public_page" filter="deceased!=yes&approved=yes&grad_year='.$gradyear.'"]')

I tried radio buttons and check boxes. I tried ‘Yes’ and ‘yes’ I set default to ‘no’ but since i have 158 previous entries, that field is null in the database. I could go into the back end and run SQL and fill in all the nulls but I was hoping the not equal to would do the trick.

Thanks for your help.
Julie

The page I need help with: [log in to see the link]