Stuck converting a string!

Hey all!
I'm looking for a little assistance as I am an amature in comparison to most of you folks.

My delema has to do with SQL, ASP, and VBSCRIPT

I have an SQL Statement:

SELECT *
FROM database.table
WHERE Course_Name IN ('MMColParam6')

MMColParam6 = varCourseTest

varCourseTest = ("test1,test2,test3") and subsquently other values (its dynamic in nature)

but SQL Says it has to be in this format:
Course_Name IN ('test1','test2','test3') if I am using multiple values, which I will be.

What I am getting is ('test1,test2,test3') - its treating my value as one string, and Im not sure how to remedy that.

I need those tidbits as characters rather than a string.  I tried adding the characters in there but it still treats them as a single string.

Does this make any sense to anyone?

Hi JBarbeal,

I don't think that it is possible to use parameters for an
IN clause; see

   http://www.visualbasicscript.com/fb.aspx?m=51227

Sorry to be destructive.

ehvbs

When I use intergers it works fine cause SQL sees it as it needs it, and the integers are passed as a 1 parameter.  I just dont know how to pass the string parameter

IN (1,2,3,4)

but when I use strings, it needs
IN ('one','two','three','four')

Maybe this will help.

What if I was to search the parameter for the ' value and replace it

this is what the constructed string for the sql statement looks like: (summary)

varCourseTest = " test1','test2','test3 "
rsMyCourseStudents__MMColParam6 = varCourseTest

recordset.Source = "SELECT *  FROM database.table  WHERE Course_Name IN ('" + Replace(rsMyCourseStudents__MMColParam6, "'", "''") + "')"

is this statement replacing the ' from string?

Oh my, I have a solution, boy I feel proud.

I changed the statement:
"SELECT *  FROM database.table  WHERE Course_Name IN ('" + Replace(rsMyCourseStudents__MMColParam6, "'", "''") + "')"

to:
"SELECT *  FROM database.table  WHERE Course_Name IN ('" + (rsMyCourseStudents__MMColParam6) + "')" 

and the statement works fine and the values I want are returned!

so now the output looks like this

test1','test2','test3

soooooooo cool! 

Congratulations!

Thanks for you help, stimulated me that much more with the link that you provided!

I shall refer you!