How to properly select records

Dan Snyder dan at macdatatech.com
Thu May 4 09:35:23 PDT 2006


Hello everyone,
 
I'm trying to select some records for printing and I'm having trouble.
Hopefully someone can help.
 
Here's my select statement.
    @PM eq 1 AND aa eq 9 AND @PZ eq 7
    select
 
The problem is when @PM is part number 649D5069H01, the select statement
also matches/selects a record for part # 649D5069H01WK.  How can I make it
select only an exact match?  
 
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?
 
Thank you,
 
Dan Snyder

IT Manager

Mercury Electronics

717-428-0222 ext.224


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060504/84835105/attachment.html


More information about the Filepro-list mailing list