I have a table with a dozen or so fields. I am trying to return all 12
fields in all records that contain an entry in the field named 'week'.
This select does that:

"SELECT * FROM foo WHERE NOT ISNULL(week) ORDER BY week DESC";

but it also includes all other records that do not have an entry in the
week field after the DESC ones have been listed. How can I modify the
query to only return the ones that have an entry in week and none of the
other ones? I thought NOT ISNULL would take care of it but it doesn't.