Hi Tom and Scott,
>
> I think your real problem is that you're trying to use "= NULL" and
> "!= NULL" where you should say IS NULL or IS NOT NULL.
Argh such a school-boy error! This is the first bit of database programming I've done for about 2 months, and I hadn't switched my C++ brain off.
I know about the <> and !=, for some reason != has always made better sense to me to read, so I tend to write it that way.
Cheers,
Andy