On Fri, 4 Feb 2011, Tim Bruce wrote:
> I believe you want to use units IS NULL; instead of units = NULL; in your> WHERE clause.
Tim,
D'oh! Of course. NULLs cannot be equal to anything.
Many thanks,
Rich