Re: Building a SQL statement...

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

You can't get there from here... :-)

The problem you have it this, if there's one value you'd want to run:

Select * from myFile where field1 in (parm1)

but if there were two values you'd need:

Select * from myFile where field1 in (parm1, parm2)

and three:

Select * from myFile where field1 in (parm1, parm2, parm3)

A single parm can have only the single value. It's one of the uglier
truths of SQL. BTW, same problem exists in SQLServer. :-)

I would recommend you just build the SQL statement as a text string so
long as you trust the values you're putting in not to be subject to SQL
injection.

-Walden