Initally, you will need to CONVERT @ID into a varchar so @SQLQuery is a string. 

This is a poor example, but if @ColName was passed in as 'Col1, Col3, Col4;...

Cows do make scents...    

You could try incorporating DIIFERENCE with a minimum return of 3 into your code...

SELECT DIFFERENCE( 'run', 'runner')

Ooops.  GPF^ did post...  

Outer Space is OURS!  We declared, so now it is fact!!!    (As to our "arab foreign policy"?  I was...

We are friends!  I just happen to be wicked, (amongst other not-so-nice attributes)....   (I suppose the "Free the Marshmallows" coalition will now rear...

You're the Marshmallow...    (I just updated the post with it acronym). 

"Once again the 'anti-cow coalition' has attempted to besmirch my good name with its spurious implications.  I call for end to this 'mean spirited, scorched earth' politicing and a return...

woman, oh woman!  Now you are on my list!!!  

"The implication that I called GF^ a 'cow' is totally unfounded and without substance!  It was probably put out by some 'anti-cow coalition'...

Tell me about it.  When I first moved there, my family would call whenever a hurricane came near N.C.  I would tell them I live 250 miles inland - they...

MUCH better solution and excellent question!   

Thanks PW.

Actually RGR'us, (man it is hard not calling you Remi) you are absolutely correct!  Oh, dopey me...  

The application should recieve ALL and...

NASA may be interested in sending Angry Bovines into Space soon! 

Just hold tight - you may be a shoe-in...   

Your original post does imply that - sorry.   

You can just add an AND to my suggestion(s): 

WHERE sub.magazine = 1

  AND...

Depending upon what sFieldNames could have in it as its string, your code does not necessarily need to be dynamic. 

You could use either a CASE statement or flow control...

Two possible approaches might be: 

SELECT customerid, name

FROM customers cs

WHERE EXISTS( SELECT *

                          FROM subcriptions sub

                          WHERE sub.customerid = cs.customerid

                             AND sub.magazine IN( 1, 3))

SELECT...