You would need to make use of the PREPARE statement to achieve this.
For example if BankList contains ‘0001, 0010, 0137’ you would use something like the following:
Eval Text=’SELECT field1,field2 FROM file WHERE BankCode In(‘ + %Trim(BankList) + ‘)’
PREPARE S1 FROM :Text
Declare C1 CURSOR FOR S1
and then read it as you would normally.
Hope it helps
All the best