create table myTable ( myFld c(10)) insert into myTable (myFld) value ("a") insert into myTable (myFld) value ("b") insert into myTable (myFld) value ("c") insert into myTable (myFld) value ("d") insert into myTable (myFld) value ("e") insert into myTable (myFld) value ("f") insert into myTable (myFld) value ("g") dimension myArray[3] myArray[1] = 'a' myArray[2] = 'b' myArray[3] = 'c' select * from myTable where ascan( myArray, myFld) <> 0 into cursor myCursor browse && 3 records: 'a', 'b', and 'c'