Hi,

Thanks a lot for the reply.

Am already checking with profiler..very poor performance as there was along string for that parameter..which works well with passing 'ALL' .But our user dont want to use 'ALL' as i explained above.

Does replacing the IN with inner join with temp table handles multi valued values also?

Can you please explain with an example?