+---------------------------------+
|             SELECT              |
+---------------------------------+
SELECT <expN> | <expC>

-----------------------------------
Activates a work area.
Return value - Numeric
-----------------------------------

SELECT chooses the active work area.

<expN> | <expC>
        Work area 1 is active by default when FoxPro is started.  You can
select a specific work area by including the work area number <expN>.

        SELECT also permits 0 as an argument.  If 0 is specified, the
lowest-numbered unused work area is selected.

        Once a database is opened in a work area, you can also select its work
area by  specifying the alias <expC> of the database.

Database Fields
---------------

Database fields in any work area can be specified in FoxPro commands and
functions.  The following formats should be used when accessing fields
which are in a work area other than the currently selected work area:

<alias>.<field> or <alias> -> <field>

+---------------------------------+
|            Example              |
+---------------------------------+
CLOSE ALL
SELECT 1
USE payments
SELECT 2
USE invoice
SELECT payments
DISPLAY
SELECT B
DISPLAY

-----------------------------------

See Also:  USE

-----------------------------------