Yes, I see what you are trying to do, but the result is still not what I am looking for. I need the vendaddr.name and that is determined by either...

I appreciate the answers, but do not think that I would get the results that I am looking for...I've revised the code a bit, which of course does not work,...

I know that it is not item #1. Sql 2005 replaced our sql 2000. How do I tell if the user has column or table level permissions? The way you...

I agree with Small town IT. I have recently begun working for a company in a small town and gave up the larger salary and endless commute to and from...