Quote Originally Posted by Jim Mulenos View Post
How do I best use an array as my list for the IN clause in a select statement? I believe it goes something like this:

SELECT * FROM {file} WERE {field} IN (myFunction(MyArray))
Code:
  Move ("'" + StrJoinFromArray(asGattung, "','") + "'") to sGattungList
  Add ("where Gattung in (" + sGattungList + ')') to sSQl
Something like the above should work.