JoinCondition or FilterCondition can be an IN clause. The IN clause is of the form IN (Value_Set) where Value_Set is Expr1[, Expr2[, ...[ ,ExprN]]]. In Visual FoxPro 9.0 the IN clause is evaluated in a different manner than previous versions; see Changes in Functionality for the Current Release for more information.

The following demonstrates the format of the IN clause.

	Copy Code
CLOSE DATABASES ALL CREATE CURSOR MyCursor(Field1 I, Field2 I) INSERT INTO MyCursor values(1,6) INSERT INTO MyCursor values(2,5) INSERT INTO MyCursor values(3,4) SELECT * FROM MyCursor WHERE MyCursor. Field1 ; IN (1,2,3,4,5)

The following code shows a summary of the main clauses of the SELECT - SQL Command:

	Copy Code
SELECT Select_List FROM Table_List ...[WITH (BUFFERING = lExpr)] [WHERE Conditions] [GROUP BY Column_List] [UNION Clause] [HAVING Conditions] [ORDER BY Column_List] [INTO Clause | TO Clause ] [Additional_Display_Options]

For more information about a particular clause of the SQL SELECT command, see the following topics:

• SELECT Clause

• FROM Clause

• SELECT - SQL Command - WITH Clause

• GROUP BY Clause

• HAVING Clause

• UNION Clause

• ORDER BY Clause

• INTO or TO Clause

• Additional Display Options

You can create filter conditions that search for data containing SQL SELECT wildcard characters, such as percent (%) and underscore (_), by using the ESCAPE clause in the WHERE clause. In the ESCAPE clause, you can specify a character that, when placed immediately before the wildcard character, indicates that the wildcard character be treated as a literal character. For more information and examples, see Filter Conditions for Queries and Views.

Reference

Other Resources