I am trying to get the following query to work. All fields of relevance
are varchars (though of different lengths). It does not sort properly.
It seems, though not absolutely certain, that when the
project_program field is null, I get problems, e.g. last names out of
order even though in the same division and project_program.
division, project_program, last_name, first_name
It's not the data. Using group by doesn't help. Any thoughts
Josh Greenberg, Esq.
One Boston Medical Ctr. Pl.
Boston, MA 02118