strings with sql

[or1980]

I have the following peace of code
"where table.field in ('field1', 'field2') ")

i need to make a string that i can put into my in statement how do i build a correct string to use inside the sql statement

[willakawill]

I have the following peace of code
"where table.field in ('field1', 'field2') ")

i need to make a string that i can put into my in statement how do i build a correct string to use inside the sql statement

Hi. I am assuming that you mean to use this statement in VB.

"WHERE table.field IN ('" _
& strYourStringHere & "','" _
& strYourNextStringHere _
& "')"