Finally, got back to it and your suggestion worked!!! It was very slick!

Thank you so much!!!!!!!:-D

that was for test purposes, the (1,2,4,8) comes in as a string. I use a "where-in" clause not the hard code.

Sorry for not getting back sooner....

Here's the actual sproc:

ALTER PROCEDURE

[Out].[programs_programsearch_select_by_various]

@CountryIDs varchar(max) = NULL,

@OptionIDs varchar(max) = NULL,

@SubjectAreaIDs varchar(max) = NULL,

@LanguageOfInstructionID int = NULL,

@GPA decimal(4,2)=null,

@MinLanguagePrerequisiteQrtrs int = null,

@ClassLevelIDs varchar(MAX) =...