Hi Lowell,

That indeed did the trick, I was sort of looking for,...

Hi David,

Thanks for your reply.

Your solution won't work, I'm affraid, because @Criteria1 applies to Column1, and @Criteria2 applies to Column2. When one of the @Criteria parameters is empty, it should...

Anybody?

I now have the following, which performs better, but doesn't seem optimal to me:

DECLARE @AllIDs table (ID int PRIMARY KEY)

IF @Criteria1<>'' AND @Criteria2=''

INSERT INTO @AllIDs (ID)

SELECT...