David,

Thanks for your reply. I origianlly tried to do it this way, but I had trouble
getting it right.

Sergey and Cetin both suggested using a table, so I went with that.

I would have preffered to build a string, but the table idea works.

Thanks



>Kevin,
>
>I wouldn't use ? parameters it makes the SPT execution a lot slower. Build your whole SQL string up and send that to your method.
>
>>Ok, I see what is happening.
>>
>>As Aergey pointed out, the parameter values are dropping out of scope
>>when the call to ._oSQLProcs.SQLCommand(sSqlCommand) happens.
>>
>>I'm open to suggesstions on the best way to do this.