Thanks. I will give that a try.

My goal was to create a temp view instead of having to create many,many permanent views.This temp view would be be used in a query built from the same stored...

could you explain how a CTE would work. I failed to mention that this is for SQL 2000.

Thanks for all of the help.

I have resolved the issue.

CASE

WHEN Director IS NOT NULL AND Director = B.Director

...

I received an answer on another forum:

WHERE

CASE

WHEN A.Director IS NOT NULL AND A.Director = B.Director THEN 1

...

Thanks, That worked great.

can you give me an example of hoe this might be done?

I thought I had it right but I need more help.

I tested my query as you suggested and it worked great, but when I added another level of complexity to...

Believe it or not but that was a big help. I needed to use the SELECT max statement but I didn't know enough SQL to know it existed. I modified...

I found my problem. It was in the WHERE clause. I fixed it and it is OK now.

I tried that and i still receive only the records that match.