>>That's the only way I've found so far, too. Depending on your ODBC driver, there may be a limitation to the length of your command string - 8K it was in my case when I last had to do this. If you have such a long list, you may be better off creating a temp table on the server, inserting your values into it, then using it in server-side select, then dropping the table. This way you chop the problem into smaller pieces - and have multiple trips to the server, of course.
>
>I will take into consideration yours comments.
>By the way. Is it possible to use Arrays instead of strings ?
>Thanks
You may find this link
http://www.sommarskog.se/arrays-in-sql-2005.html helpful.
If it's not broken, fix it until it is.
My Blog