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