>>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.
For those three fields, nulls are allowed.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"