>Sure, I hope to get to it later today. I have to add 100,000 records to the two tables to do a true simuation. With my tests so far (using about 30,000 records), the other query was much faster but I won't know a real comparison until I get enough records in the table to test.
Great, thanks. Also don't forget to introduce NULLs into the mixture.
If it's not broken, fix it until it is.
My Blog