Using IN clause with variable list

[eoneon123]

Is it possible to select values from a variable list inside a SELECT statement using the IN clause? I've been trying to get to this work but I think the SELECT statement is just pulling off the first value in the list.  I've been using the below syntax. Any thoughts?

 

 

ExecuteSQL ( "SELECT Field FROM Table WHERE Field IN (?) "; "" ; ¶ ; $List )

 

[dansmith65]

http://www.filemakerhacks.com/?p=7016