<html>
Dear list-<br>
<br>
I have searched the list for something like this and have come up
empty.<br>
<br>
After getting everything to work I find my queries are not returning the
features I desire. Rather they are returning too many 'hits.'
The search expression is obviously operating as an SQL 'like' with
wildcards at each end of the specified value rather than an SQL
'='. For example,<br>
<br>
qstring = |101011| <br>
<br>
when applied to my parcel data returns all parcels that have the 101011
characters present in their value, no matter where they are in the
string. Thus I get parcels 12 parcels starting with 101011,
but I also get parcels like 522<b>101011</b>' which I do not want.<br>
<br>
Similarly, when searching for a land use code of 'A' I return all
the 'A' land use polygons, but I also get all the '<b>A</b>C-WR'
and any others that have an '<b>A</b>' in them which I do not want
located.<br>
<br>
So my question is:<br>
<br>
Am I doing somethin wrong ? How do I specify an expression that
should be an equality '=' rather than a 'like' ? Is there a
wildcard that can be included in the expression statement so that it
operates as I define it (e.g. (101011% or A%)) rather than assuming
wildcards are part of the expression at beginning and end. This is
obviously not following standard SQL formatting so what are the
definitions that apply to expressions and how can I generate the query
results I need. Queries that return improper results make the
programmer look rather foolish - and of course I would like to avaoid
that appearance ! I figure there must be a way - and if not, then
there really needs to be a way - but what is it ?<br>
<br>
Thanks in advance,<br>
<br>
Ken Stumpf<br>
<br>
<BR>
<div>Geographic Resource Solutions</div>
<div>1125 16th Street, Suite 213</div>
<div>Arcata, CA 95521</div>
<div>Phone: (707) 822-8005</div>
<div>Fax: (707) 822-2864</div>
<br>
<a href="http://www.grsgis.com/" EUDORA=AUTOURL>www.grsgis.com</a>
</html>