Queries allows to extract partial data for migrating to SQL Server. The following examples are provided to illustrate how to use queries for particular purposes. Assume that we have table "Table1" as below:
Table1( ID Integer, FName Text(50), LName Text(50), Birthday Date, Notes Memo );
Example 1. Convert certain records.
SELECT * FROM Table1 WHERE ID > 1000
Example 2. Choose and rename columns.
SELECT FName as FirstName, LName as LastName FROM Table1
Example 3. Skip records containing NULL values.
SELECT * FROM Table1 WHERE not isnull(Notes)