testROSEWATERSelect distinct RSP From Products Where 1=1 And List='True' And (Subcategory1_ID like '%,' + @Field + ',%' Or Subcategory1_ID like @Field + ',%' Or Subcategory1_ID like '%,' + @Field Or Subcategory1_ID = @Field ) Order By RSP