Ah, and so it turns out that in my live table it IS datetime.

My bad, and I'm working hard to learn the art and craft of creating well thought out...

Sure, that is cleaner, for sure.

The table was small, though, and I was able to enjoy acceptable speed using the NOT EXISTS route.

I've saved this for future use, though, and...

Hey, that was great!

I used the NOT EXISTS version, and got just what I needed!

Funny that I'd gotten fairly close!

Thanks again to everyone.

Yes, there are NULLs in there.

Thanks, too.

I'll bring them over for testing shortly.

Putting out quick fire...

Thanks for taking a look at this!

I get no errors, but no returns, either.

Thank you so much!

I'll refer back on my next post, too.

I work very hard to work these things out on my own, and am very appreciative and respectful of the...

Thanks! I'll give that a try shortly!

Thanks.

That's closer to what I'm after this time around, but your previous post is also quite interesting to me.

I think I may have a large number of duplicates, so I...

Thanks!

This is my first brush with CET functions, and I'm sure I'll be using this more as time goes on.

OK, it seems to work great!

I added some limiters to narrow it down to a single record that I knew should be modified by the query, and it did the...

Hey, thanks for taking a look.

I added the error, and amended my query in the post, as I'd actually written it with the 'in' clause to start with but messed...