<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<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>I tried
comparing the lengths of @PM and field 1 using dlen and len but dlen and len
both returned the full field length of field 1 (which was 20) rather than the
actual length of the text within the field which is 11 for the correct
record and 13 for the record I don't want matched. I can't use a set
length, since part numbers vary in length. Any
suggestions?</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>Thank
you,</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><!-- Converted from text/plain format -->
<P class=MsoPlainText style="MARGIN: 0in 0in 0pt" align=left><FONT
face="Courier New" size=2>Dan Snyder</FONT></P>
<P class=MsoPlainText style="MARGIN: 0in 0in 0pt" align=left><FONT
face="Courier New" size=2>IT Manager</FONT></P>
<P class=MsoPlainText style="MARGIN: 0in 0in 0pt" align=left><FONT
face="Courier New" size=2>Mercury Electronics</FONT></P>
<P class=MsoPlainText style="MARGIN: 0in 0in 0pt" align=left><FONT
face="Courier New" size=2>717-428-0222 ext.224</FONT><FONT
face="Courier New"><BR></P></FONT></SPAN></FONT></DIV></BODY></HTML>