<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="../../Templates/DocTemp.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>SQL Reference - SELECT Statement Syntax - WHERE Clause</title>
<!-- InstanceEndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../../docs.css" rel="stylesheet" type="text/css">
<script language="JavaScript1.2" src="../../docs.js"></script>
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable -->
</head>

<body>
<table width="100%" class="lightblue" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><a href="http://www.omnidex.com"><img src="../../images/flatlogo.gif" width="95" height="25" hspace="3" vspace="3" border="0"></a></td>
    <td><img src="../../images/omnidex.gif" width="109" height="25" hspace="3" vspace="3"></td>
    <td align="right" valign="top"><p class="banner"><a href="../../Contents.htm">Contents</a> 
        | <a href="../../Quick%20Links.htm">Quick Links</a></p></td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="175" class="bar"><p class="banner">&nbsp;</p></td>
    <td align="right" class="bar"> <!-- InstanceBeginEditable name="Section Title" -->
      <h1>SQL Reference - SELECT Statement Syntax</h1>
      <!-- InstanceEndEditable --></td>
  </tr>
  <tr> 
    <td width="175" class="left1 lightblue"><img src="../../images/blank.gif" width="10" height="20"> 
    </td>
    <td valign="top" class="left1 lightblue">&nbsp; </td>
  </tr>
  <tr> 
    <td width="175" valign="top" class="left"><!-- InstanceBeginEditable name="leftnav" --> 
      <p><a href="SELECT%20Statement.htm">Syntax</a></p>
      <p><a href="SELECT%20List.htm">SELECT List</a></p>
      <p><a href="FROM%20Clause.htm">FROM</a></p>
      <p>WHERE</p>
      <p><a href="GROUP%20BY%20Clause.htm">GROUP BY / HAVING</a></p>
      <p><a href="ORDER%20BY%20Clause.htm">ORDER BY</a></p>
      <p><a href="Criteria%20Conditioning.htm">Criteria Conditioning</a></p>
      <p class="line">&nbsp;</p>
      <p><a href="../SQL%20Reference.htm">SQL Reference</a></p>
      <p><a href="../Joins.htm">Joins</a></p>
      <p><a href="../Nested%20Queries.htm">Nested Queries</a></p>
      <p><a href="../SET%20Operations.htm">Set Operations</a></p>
      <p><a href="../ON%20CURSOR%20ON%20INSTANCE.htm">ON CURSOR | INSTANCE</a></p>
      <p><a href="../WITH%20Options.htm">WITH Options</a></p>
      <p><a href="../Commands.htm">Commands</a></p>
      <p><a href="../Functions.htm">Functions</a></p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --></td>
    <td valign="top" class="content"> <!-- InstanceBeginEditable name="Content" --> 
      <h2>WHERE Clause</h2>
      <p><a href="#equal"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        = right_operand (equal to)</a></p>
      <p><a href="#lessthan"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        &lt; right_operand (less than)</a></p>
      <p><a href="#greaterthan"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        &gt; right_operand (greater than)</a></p>
      <p><a href="#lessequal"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        &lt;= right_operand (less than or equal to)</a></p>
      <p><a href="#greaterequal"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        &gt;= right_operand (greater than or equal to)</a></p>
      <p><a href="#lessgreater"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        &lt;&gt; right_operand (not equal to)</a></p>
      <p><a href="#exclamationequal"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        != right_operand (not equal to)</a></p>
      <p><a href="#in"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        in (value-list | Nested Select)</a></p>
      <p><a href="#like"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">left_operand 
        like right_operand_with_wildcard</a></p>
      <p><a href="#exists"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">exists 
        (Nested Select) - MUST RETURN ONLY ONE COLUMN.</a></p>
      <p><a href="#nested"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">=, 
        &lt;, &gt;, &lt;=, &gt;=, &lt;&gt;, like - Nested Select</a> that GUARANTEES 
        to return ONLY ONE ROW. MUST RETURN ONLY ONE COLUMN.<br>
        <a href="#innested"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">in 
        (Nested Select)</a> - Can return 0 or more rows. MUST RETURN ONLY ONE 
        COLUMN.</p>
      <p><a href="#notandor"><img src="../../images/arrow2.gif" width="10" height="10" hspace="5" border="0">NOT, 
        AND, OR</a> with any of the above criteria predicates</p>
      <p class="line2">&nbsp;</p>
      <h3>left_operand and right_operand can contain any of the following:</h3>
      <ul>
        <li>Columns </li>
        <li>Table Qualified Columns - table.column </li>
        <li>Column alias </li>
        <li>Literals </li>
        <li>Constants </li>
        <li>Expressions </li>
        <li>Wildcards </li>
        <li>$VALUES, $ROWID, $ODXID </li>
        <li>Omnidex Sentinel Character </li>
        <li>IS NULL - This will not be an optimized query! </li>
        <li>Use parenthesis to force order of precedence.</li>
      </ul>
      <p class="line">&nbsp;</p>
      <h3><a name="equal"></a>left_operand = right_operand (equal to)</h3>
      <p>SELECT company, contact FROM customers where company='systems'</p>
      <p>SELECT customers.company, orders.order_no FROM customers, orders WHERE<br>
        customers.customer_no=orders.customer_no AND (orders.status='shipped' 
        OR<br>
        orders.status='pending')</p>
      <p class="line">&nbsp;</p>
      <h3> <a name="lessthan"></a>left_operand &lt; right_operand (less than)</h3>
      <p class="ex">SELECT company FROM customers WHERE customer_no &lt; 100</p>
      <p class="line">&nbsp;</p>
      <h3><a name="greaterthan"></a>left_operand &gt; right_operand (greater than)</h3>
      <p class="ex">SELECT customer_no, product_no FROM orders WHERE status='back' 
        AND<br>
        (quantity*amount) &gt; 50 ORDER BY 1, 2</p>
      <p class="line">&nbsp;</p>
      <h3><a name="lessequal"></a>left_operand &lt;= right_operand (less than 
        or equal to)</h3>
      <p class="ex">SELECT * FROM inventory WHERE onhand &lt;= 10</p>
      <p class="line">&nbsp;</p>
      <h3><a name="greaterequal"></a>left_operand &gt;= right_operand (greater 
        than or equal to)</h3>
      <p class="ex">SELECT company FROM customers WHERE customer_no &lt; 100</p>
      <p class="line">&nbsp;</p>
      <h3><a name="lessgreater"></a>left_operand &lt;&gt; right_operand (not equal 
        to)</h3>
      <p class="ex">SELECT company, state FROM customers WHERE state &lt;&gt; 
        'CO'</p>
      <p class="line">&nbsp;</p>
      <h3><a name="exclamationequal"></a>left_operand != right_operand (not equal 
        to)</h3>
      <p class="ex">SELECT company, state FROM customers WHERE state != 'CA'</p>
      <p class="line">&nbsp;</p>
      <h3><a name="in"></a>left_operand in (value-list | Nested Select)</h3>
      <p class="ex">SELECT company, state FROM customers WHERE state IN ('A?', 
        'C?')</p>
      <p class="ex">SELECT company, state FROM customers WHERE state NOT IN ('AZ', 
        'CA')</p>
      <p class="ex">SELECT * FROM orders WHERE total &gt; (SELECT avg(total) FROM 
        orders)</p>
      <p class="line">&nbsp;</p>
      <h3><a name="like"></a>left_operand like right_operand_with_wildcard</h3>
      <p class="ex">SELECT company, state FROM customers WHERE state like 'C?'</p>
      <p class="ex">SELECT company, state FROM customers WHERE company = 'sys%'</p>
      <p class="line">&nbsp;</p>
      <h3><a name="exists"></a>exists (Nested Select) </h3>
      <p>Evaluates false if nested select returns 0 rows, true otherwise. In this 
        example, all customer records will be returned.</p>
      <p class="ex">SELECT c.company FROM customers c WHERE exists (SELECT * FROM 
        orders o <br>
        WHERE o.status='back')</p>
      <p class="line">&nbsp;</p>
      <h3><a name="nested"></a>=, &lt;, &gt;, &lt;=, &gt;=, &lt;&gt;, !=, like 
        (Nested Select)</h3>
      <p>These selects MUST return only one column and only one row.</p>
      <p class="ex">SELECT * FROM orders WHERE customer_no = (SELECT customer_no 
        FROM customers<br>
        WHERE company='Dynamic Information Systems')</p>
      <p class="ex">SELECT customer_no, order_date, STATUS FROM orders WHERE product_no 
        like<br>
        (SELECT product_no FROM products WHERE product_no='SUP16210')</p>
      <p class="line">&nbsp;</p>
      <h3><a name="innested"></a>in (Nested Select)</h3>
      <p class="ex">SELECT distinct customer_no, status, product_no FROM orders 
        WHERE product_no in <br>
        (SELECT product_no FROM products WHERE product_name='monitor')</p>
      <p class="line">&nbsp;</p>
      <h3><a name="notandor"></a>NOT, AND, OR</h3>
      <p>The following two statements return identical results, but note the placement 
        of the NOT operator.</p>
      <p class="ex">SELECT company, state FROM customers WHERE company='%systems 
        or software' <br>
        AND state NOT in ('AZ', 'CA')</p>
      <p class="ex">SELECT company, state FROM customers WHERE company='%systems 
        or software' <br>
        AND NOT state in ('AZ', 'CA')</p>
      <p>The next two statements return identical results, but note the differences 
        in the WHERE clause with the Omnidex sentinel character and OR operator.</p>
      <p class="ex">SELECT company, state FROM customers WHERE company='%systems 
        or software'</p>
      <p class="ex">SELECT company, state FROM customers WHERE company='systems' 
        OR<br>
        company='software'</p>
      <p>The next two statements return companies located in Boulder CO, Boulder 
        Creek CA, and Denton TX, but NOT Denver CO.</p>
      <p class="ex">SELECT company, city, state FROM customers WHERE (city like 
        'boul%' <br>
        AND state in ('CO', 'CA')) OR (city like 'den%' AND state != 'CO')</p>
      <p class="ex">SELECT company, city, state FROM customers WHERE (city like 
        'boul%' <br>
        AND state in ('CO', 'CA')) OR (city like 'den%' AND NOT state = 'CO')</p>
      <p>&nbsp;</p>
      <p>&nbsp;</p>
      <!-- InstanceEndEditable --><P align="right"><a href="#">Top</a> </P>
	  </td>
  </tr>
  <tr>
    <td width="175" class="bbar">
<p>&nbsp;</p></td>
    <td align="right" valign="middle" class="bbar"> <p class="banner">Omnidex 
        Version 4.1 Build 1 - E10.04 - Dynamic Information Systems Corporation 
        - Copyright &copy; 2004</p></td>
  </tr>
</table>
<div class="menu0" id="m1" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');"> 
  <a href="../../index.htm">Home</a></div>      
<div class="menu0" id="m2" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');"> 
  <a href="../../Omnidex%20Concepts/Omnidex%20Overview.htm">Omnidex</a></div>      
<div class="menu0" id="m3" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');"> 
  <a href="../../Getting%20Started/Getting%20Started.htm">Getting Started </a></div>      
<div class="menu0" id="m4" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');"> 
  <a href="../../Development/Development.htm">Development</a></div>      
<div class="menu0" id="m5" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');"> 
  <a href="../../Utilities/Utilities.htm">Utilities</a></div>      
<div class="menu0" id="m6" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');"> 
  <a href="../../Appendix/Appendix.htm">Appendix</a></div>
    <td>&nbsp;</td>
  </tr>
</table> 
<table id="s1" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m1'); changeVisibility('visible','s1');" onMouseOut="changeClass('menu0','m1'); changeVisibility('hidden','s1');">
  <tr> 
    <td id="s11" class="menu1" onMouseOver="changeClass('menu0','s11');" onMouseOut="changeClass('menu1','s11');"><a href="../../Whats%20New.htm">What's 
      New!</a></td>
  </tr>
  <tr> 
    <td id="s12" class="menu1" onMouseOver="changeClass('menu0','s12');" onMouseOut="changeClass('menu1','s12');"><a href="../../Quick%20Links.htm">Quick 
      Links</a></td>
  </tr>
  <tr> 
    <td id="s13" class="menu1" onMouseOver="changeClass('menu0','s13');" onMouseOut="changeClass('menu1','s13');"><a href="../../Contents.htm">Contents</a></td>
  </tr>
</table>
<table id="s2" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m2'); changeVisibility('visible','s2');" onMouseOut="changeClass('menu0','m2'); changeVisibility('hidden','s2');">
  <tr> 
    <td id="s21" class="menu1" onMouseOver="changeClass('menu0','s21');" onMouseOut="changeClass('menu1','s21');"><a href="../../Omnidex%20Concepts/Features/Features.htm">Features</a></td>
  </tr>
  <tr> 
    <td id="s22" class="menu1" onMouseOver="changeClass('menu0','s22');" onMouseOut="changeClass('menu1','s22');"><a href="../../Omnidex%20Concepts/Indexing%20Strategies/Indexing%20Strategies.htm">Indexing 
      Strategies</a></td>
  </tr>
  <tr> 
    <td id="s23" class="menu1" onMouseOver="changeClass('menu0','s23');" onMouseOut="changeClass('menu1','s23');"><a href="../../Omnidex%20Concepts/Indexing%20Options/Indexing%20Options.htm">Indexing 
      Options </a></td>
  </tr>
  <tr> 
    <td id="s24" class="menu1" onMouseOver="changeClass('menu0','s24');" onMouseOut="changeClass('menu1','s24');"><a href="../../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Index 
      Maintenance </a></td>
  </tr>
  <tr> 
    <td id="s25" class="menu1" onMouseOver="changeClass('menu0','s25');" onMouseOut="changeClass('menu1','s25');"><a href="../../Omnidex%20Concepts/Partitioning/Partitioning.htm">Optimization</a></td>
  </tr>
  <tr> 
    <td id="s26" class="menu1" onMouseOver="changeClass('menu0','s26');" onMouseOut="changeClass('menu1','s26');"><a href="../../Omnidex%20Concepts/Index%20Maintenance/Index%20Maintenance.htm">Partitioning</a></td>
  </tr>
  <tr> 
    <td id="s27" class="menu1" onMouseOver="changeClass('menu0','s27');" onMouseOut="changeClass('menu1','s27');"><a href="../../Omnidex%20Concepts/Text/Omnidex%20Text.htm">Omnidex Text</a></td>
  </tr>
</table>
<table id="s3" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m3'); changeVisibility('visible','s3');" onMouseOut="changeClass('menu0','m3'); changeVisibility('hidden','s3');">
  <tr> 
    <td id="s31" class="menu1" onMouseOver="changeClass('menu0','s31');" onMouseOut="changeClass('menu1','s31');"><a href="../../Getting%20Started/1%20-%20Installation%20and%20Setup.htm">Server 
      Setup Guides</a></td>
  </tr>
  <tr> 
    <td id="s32" class="menu1" onMouseOver="changeClass('menu0','s32');" onMouseOut="changeClass('menu1','s32');"><a href="../../Getting%20Started/Omnidex%20Client/Windows%20Client.htm">Windows 
      Client</a></td>
  </tr>
  <tr> 
    <td id="s33" class="menu1" onMouseOver="changeClass('menu0','s33');" onMouseOut="changeClass('menu1','s33');"><a href="../../Database%20Platforms/Supported%20Database%20Platforms.htm">Database 
      Platforms </a></td>
  </tr>
  <tr> 
    <td id="s34" class="menu1" onMouseOver="changeClass('menu0','s34');" onMouseOut="changeClass('menu1','s34');"><a href="../../Environment%20Catalog/Environment%20Catalog.htm">Environment 
      Catalog</a> </td>
  </tr>
</table>
<table id="s4" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m4'); changeVisibility('visible','s4');" onMouseOut="changeClass('menu0','m4'); changeVisibility('hidden','s4');">
  <tr> 
    <td id="s41" class="menu1" onMouseOver="changeClass('menu0','s41');" onMouseOut="changeClass('menu1','s41');"><a href="../../SQL%20Reference/SQL%20Reference.htm">SQL 
      Reference</a> </td>
  </tr>
  <tr> 
    <td id="s42" class="menu1" onMouseOver="changeClass('menu0','s42');" onMouseOut="changeClass('menu1','s42');"><a href="../../Development/ODBC/ODBC.htm">ODBC</a></td>
  </tr>
  <tr> 
    <td id="s43" class="menu1" onMouseOver="changeClass('menu0','s43');" onMouseOut="changeClass('menu1','s43');"><a href="../../Development/JDBC/JDBC.htm">JDBC</a></td>
  </tr>
  <tr> 
    <td id="s44" class="menu1" onMouseOver="changeClass('menu0','s44');" onMouseOut="changeClass('menu1','s44');"><a href="../../Development/OmniAccess%20API/OmniAccess%20API.htm">OmniAccess 
      API</a></td>
  </tr>
  <tr> 
    <td id="s45" class="menu1" onMouseOver="changeClass('menu0','s45');" onMouseOut="changeClass('menu1','s45');"><a href="../../Development/Debugging/OMNIDEX_DEBUG.htm">Debugging</a></td>
  </tr>
</table>
<table id="s5" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m5'); changeVisibility('visible','s5');" onMouseOut="changeClass('menu0','m5'); changeVisibility('hidden','s5');">
  <tr> 
    <td id="s51" class="menu1" onMouseOver="changeClass('menu0','s51');" onMouseOut="changeClass('menu1','s51');"><A href="../../Utilities/DBINSTAL/DBINSTAL.htm">DBINSTAL</A></td>
  </tr>
  <tr> 
    <td id="s52" class="menu1" onMouseOver="changeClass('menu0','s52');" onMouseOut="changeClass('menu1','s52');"><a href="../../Utilities/DSEDIT/DSEDIT.htm">DSEDIT</a></td>
  </tr>
  <tr> 
    <td id="s53" class="menu1" onMouseOver="changeClass('menu0','s53');" onMouseOut="changeClass('menu1','s53');"><a href="../../Utilities/NSADMIN/NSADMIN.htm">NSADMIN</a></td>
  </tr>
  <tr> 
    <td id="s54" class="menu1" onMouseOver="changeClass('menu0','s54');" onMouseOut="changeClass('menu1','s54');"><a href="../../Utilities/OACOMP/OACOMP.htm">OACOMP</a></td>
  </tr>
  <tr> 
    <td id="s55" class="menu1" onMouseOver="changeClass('menu0','s55');" onMouseOut="changeClass('menu1','s55');"><a href="../../Utilities/OADECOMP/OADECOMP.htm">OADECOMP</a></td>
  </tr>
  <tr> 
    <td id="s56" class="menu1" onMouseOver="changeClass('menu0','s56');" onMouseOut="changeClass('menu1','s56');"><a href="../../Utilities/OAHELPER/OAHELPER.htm">OAHELPER</a></td>
  </tr>
  <tr> 
    <td id="s57" class="menu1" onMouseOver="changeClass('menu0','s57');" onMouseOut="changeClass('menu1','s57');"><A href="../../Utilities/ODXAIM/ODXAIM.htm">ODXAIM</A></td>
  </tr>
  <tr> 
    <td id="s58" class="menu1" onMouseOver="changeClass('menu0','s58');" onMouseOut="changeClass('menu1','s58');"><a href="../../Utilities/ODXMAKE/ODXMAKE.htm">ODXMAKE</a></td>
  </tr>
  <tr> 
    <td id="s59" class="menu1" onMouseOver="changeClass('menu0','s59');" onMouseOut="changeClass('menu1','s59');"><a href="../../Utilities/ODXNET/ODXNET.htm">ODXNET</a></td>
  </tr>
  <tr> 
    <td id="s510" class="menu1" onMouseOver="changeClass('menu0','s510');" onMouseOut="changeClass('menu1','s510');"><A href="../../Utilities/ODXQUERY/ODXQUERY.htm">ODXQUERY</A></td>
  </tr>
  <tr> 
    <td id="s511" class="menu1" onMouseOver="changeClass('menu0','s511');" onMouseOut="changeClass('menu1','s511');"><a href="../../Utilities/ODXSQL/ODXSQL.htm">ODXSQL</a></td>
  </tr>
  <tr> 
    <td id="s512" class="menu1" onMouseOver="changeClass('menu0','s512');" onMouseOut="changeClass('menu1','s512');"><a href="../../Utilities/REGMAINT/REGMAINT.htm">REGMAINT</a></td>
  </tr>
  <tr> 
    <td id="s513" class="menu1" onMouseOver="changeClass('menu0','s513');" onMouseOut="changeClass('menu1','s513');"><A href="../../Utilities/REGTEST/REGTEST.htm">REGTEST</A></td>
  </tr>
  <tr> 
    <td id="s514" class="menu1" onMouseOver="changeClass('menu0','s514');" onMouseOut="changeClass('menu1','s514');"><a href="../../Utilities/SNOWGEN/SNOWGEN.htm">SNOWGEN</a></td>
  </tr>
  <tr> 
    <td id="s515" class="menu1" onMouseOver="changeClass('menu0','s515');" onMouseOut="changeClass('menu1','s515');"><a href="../../Utilities/SYSINFO/SYSINFO.htm">SYSINFO</a></td>
  </tr>
  <tr> 
    <td id="s516" class="menu1" onMouseOver="changeClass('menu0','s516');" onMouseOut="changeClass('menu1','s516');"><a href="../../Utilities/VERSIONS/VERSIONS.htm">VERSIONS</a></td>
  </tr>
  <tr> 
    <td id="s517" class="menu1" onMouseOver="changeClass('menu0','s517');" onMouseOut="changeClass('menu1','s517');"><a href="../../Utilities/VIEWGEN/VIEWGEN.htm">VIEWGEN</a></td>
  </tr>
</table>
<table id="s6" border="0" cellspacing="0" cellpadding="0" onMouseOver="changeClass('menu1','m6'); changeVisibility('visible','s6');" onMouseOut="changeClass('menu0','m6'); changeVisibility('hidden','s6');">
  <tr> 
    <td id="s61" class="menu1" onMouseOver="changeClass('menu0','s61');" onMouseOut="changeClass('menu1','s61');"><a href="../../Appendix/Cardinality.htm">Cardinality</a></td>
  </tr>
  <tr> 
    <td id="s62" class="menu1" onMouseOver="changeClass('menu0','s62');" onMouseOut="changeClass('menu1','s62');"><a href="../../Appendix/Date%20Formats.htm">Date 
      Formats </a></td>
  </tr>
  <tr> 
    <td id="s63" class="menu1" onMouseOver="changeClass('menu0','s63');" onMouseOut="changeClass('menu1','s63');"><a href="../../Appendix/Environment%20Variables.htm">Environment 
      Variables </a></td>
  </tr>
  <tr> 
    <td id="s64" class="menu1" onMouseOver="changeClass('menu0','s64');" onMouseOut="changeClass('menu1','s64');"><a href="../../Appendix/File%20Name%20Handling.htm">File 
      Name Handling</a></td>
  </tr>
  <tr> 
    <td id="s65" class="menu1" onMouseOver="changeClass('menu0','s65');" onMouseOut="changeClass('menu1','s65');"><a href="../../Appendix/Glossary%20A.htm">Glossary</a></td>
  </tr>
  <tr> 
    <td id="s66" class="menu1" onMouseOver="changeClass('menu0','s66');" onMouseOut="changeClass('menu1','s66');"><a href="../../Appendix/Null.htm">Null</a></td>
  </tr>
  <tr> 
    <td id="s67" class="menu1" onMouseOver="changeClass('menu0','s67');" onMouseOut="changeClass('menu1','s67');"><a href="../../Appendix/OAGLOBAL.htm">OAGLOBAL</a></td>
  </tr>
  <tr> 
    <td id="s68" class="menu1" onMouseOver="changeClass('menu0','s68');" onMouseOut="changeClass('menu1','s68');"><a href="../../Appendix/Operating%20Limits.htm">Operating 
      Limits</a></td>
  </tr>
  <tr> 
    <td id="s69" class="menu1" onMouseOver="changeClass('menu0','s69');" onMouseOut="changeClass('menu1','s69');"><a href="../../Appendix/Provided%20Managed%20Synonym%20Lists.htm">Managed 
      Synonym Lists</a></td>
  </tr>
  <tr> 
    <td id="s70" class="menu1" onMouseOver="changeClass('menu0','s70');" onMouseOut="changeClass('menu1','s70');"><a href="../../Appendix/Reserved%20Words.htm">Reserved 
      Words</a></td>
  </tr>
  <tr> 
    <td id="s71" class="menu1" onMouseOver="changeClass('menu0','s71');" onMouseOut="changeClass('menu1','s71');"><a href="../../Appendix/Supported%20Datatypes.htm">Supported 
      Data Types</a></td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
<!-- InstanceEnd --></html>
