How about trying...
Test = "'191','193'"
"Select * from Table1 where office IN("+Test+")"
>Hi. I am trying to use a parameter in a IN clause with SQL Server backend. The returned cursor is always empty. I tried to populate the^parameter with :
>
>Test = '191','193'
>Test = "'191','193'"
>Test = ("'191','193'")
>
>Nothing is working.
>
>There is the SQL
>
>"Select * from Table1 where office IN (?Test)"
>
>Any idea ?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown