the query is based on 17 tables. If I do a straight select from the table in question, it comes back fine. If I use an = in...

Yes, I tried that also, that also never comes back.

The only difference I see between the execution plans, is it uses a clustered index seek for the original...

I've used xp_sendmail as the last step of the job to send attachments like that.

Thanks! I tried "close to that" before, but I had the ? in quotes for some reason.

I live in the Minneapolis/St. Paul MN area, and I've seen a definite pickup in the number of SQL DBA jobs from last year to this year. It looks...

Thanks for the help! After a little more research, that worked perfect!