How to properly select records
Howard Wolowitz
howiewz at beonthenet.com
Thu May 4 09:57:27 PDT 2006
----- Original Message -----
From: Dan Snyder
To: filepro-list at seaslug.org
Sent: Thursday, May 04, 2006 12:35 PM
Subject: How to properly select records
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?
____________________________________________________________________________
Try:
@pm < "" eq 1 < "" and aa eq 9 and @PZ < "" eq 7 < ""
Howie
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060504/dadd9249/attachment-0001.html
More information about the Filepro-list
mailing list