Hi Guys,

Thanks for the replies.  I tried the 'temp table' method with a temp table datatype instead of an actual temp table as its supposed to be faster.   It...

The ID has a clustered index on it.

@LOCATION CHAR(25) = ‘ ‘,

AND ((@LOCATION = ' ')OR(LOCATION = @LOCATION) OR (@LOCATION IS NULL AND LOCATION IS NULL))

I would think that your last OR condition is never going to...