<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=dan@macdatatech.com href="mailto:dan@macdatatech.com">Dan Snyder</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=filepro-list@seaslug.org
href="mailto:filepro-list@seaslug.org">filepro-list@seaslug.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, May 04, 2006 12:35
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> How to properly select
records</DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT><BR></DIV>
<DIV><FONT face="Courier New" size=2><SPAN class=764441716-04052006>Hello
everyone,</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><SPAN class=764441716-04052006>I'm trying
to select some records for printing and I'm having trouble. Hopefully
someone can help.</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><SPAN class=764441716-04052006>Here's my
select statement.</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006> @PM eq 1 AND aa eq 9 AND @PZ eq
7</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006> select</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><SPAN class=764441716-04052006>The
problem is when @PM is part number 649D5069H01, the
</SPAN></FONT><FONT face="Courier New" size=2><SPAN
class=764441716-04052006>select statement also matches/selects a record for
part # 649D5069H01WK. How can I make it select only an exact
match? </SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006>____________________________________________________________________________</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006>Try:</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><SPAN class=764441716-04052006> @pm
< "" eq 1 < "" and aa eq 9 and @PZ < "" eq 7 <
""</SPAN></FONT></DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006></SPAN></FONT> </DIV>
<DIV><FONT face="Courier New" size=2><SPAN
class=764441716-04052006>Howie</SPAN></FONT></DIV></BLOCKQUOTE></BODY></HTML>