Description:

• Defines the where clause for a stored query.
• Defines attribute queries on a dataset.

Restrictions:

• A where statement is required for all stored queries and when joining ArcSDE tables. Otherwise, where is optional.

Notes:

• For information on joining tables and setting up query clauses, see SPATIALQUERY. QUERY handles only attributes, while SPATIALQUERY handles both attribute and spatial queries. It is recommended that you use SPATIALQUERY for all query statements with the exception of stored queries.
• QUERY must be used when setting up a stored query.
• Joined tables cannot be used with a QUERY in STOREDQUERY.
• When ArcSDE is used, the subfields attribute has the full long format of the field names (e.g., MD.GDT_STATE.AREA). For shapefiles, the subfields attribute contains the field names in short format (e.g., AREA).
• In a stored query, only one variable can be used.
• Some symbols must be "escaped" inside a where expression:
  
        ampersand (&) is escaped to &
        double quotes (") are escaped to "
        single quotes (') are escaped to '
        greater than (>) is escaped to >
        less than (<) is escaped to &lt;
• The following operators work in a where clause: =, >, >=, <, <=, <>, LIKE, BETWEEN, IN, NOT IN. The following are not valid: ORDER BY and DISTINCT.
• Querying with dates. The syntax for querying dates is the same regardless of the locale. A date query uses the following syntax:
  
  {ts 'YYYY-MM-DD hh:mi:ss'}
  
  where
  

  YYYY	Year	Required	Use four digits for the year.
  MM	Month (01-12)	Required	Use two digits for the month. March is 03.
  DD	Day (01-31)	Required	Use two digits for the day. The fourth is 04.
  hh	Hour (00-23)	Optional	Use a 24-hour clock. 8 a.m. is 08, and 8 p.m. is 20.
  mi	Minutes (00-59)	Optional	Use two digits for the minutes. If minutes is used, hours must also be included.
  ss	Seconds (00-59)	Optional	Use two digits for the seconds. If seconds is used, hours and minutes must also be included.

  
  The year, month, and day are each separated by a dash (-). The hour, minutes, and seconds are each separated by a colon (:). The date is enclosed in single quotes (') inside curly brackets ({}). Before the date, ts (for time stamp) must be included.
  
  For 8:03:23 a.m. January 4, 2000, the query on a DBF file looks like:
  <QUERY where="MYDATE = {ts '2000-01-04 08:03:32'}" />
  
  For 9:18 p.m. March 8, 2002, the query on an ArcSDE layer looks like:
  <QUERY where="ARCSDE.TABLE.MYDATE = {ts '2002-03-08 21:18:00'}" />
  

Attribute Descriptions for QUERY:

Examples for QUERY: