Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "Mark" <maiden.mark@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Query from Forms not using Index
Date: 19 Apr 2005 02:54:30 -0700
Organization: http://groups.google.com
Lines: 4
Message-ID: <1113904470.326034.37530@g14g2000cwa.googlegroups.com>
References: <1113899744.185521.136890@g14g2000cwa.googlegroups.com>
   <d42jja$npr$1@hercules.btinternet.com>
NNTP-Posting-Host: 84.203.136.124
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1113904474 508 127.0.0.1 (19 Apr 2005 09:54:34 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 19 Apr 2005 09:54:34 +0000 (UTC)
In-Reply-To: <d42jja$npr$1@hercules.btinternet.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=84.203.136.124;
   posting-account=_YJfAg0AAABYMn3dqRWl4Mu55RLs1nVh
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:240744

That was it! When I ran the query without the quotes it did a full
table scan. We're going to change the form now to eliminate this. THANK
YOU very much for your help, much appreciated!