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