Weird SQL problems with Filemaker...???

[angelleye]

I've got a Filemaker file that stores auction information for eBay. One field I have in there is called Sandbox is has a Yes, No drop down menu where you can select Yes or No and it holds that value.

When I'm creating a recordset in my ASP scripts outside of FM, If I use the following:

SELECT Auction_Number, Auction_ID

FROM Auctions

WHERE Auction_Status = 'Current' AND Sandbox = 'Yes'

that works perfectly. It returns only the auction records where Sandbox has been set to Yes.

Now I'm trying to return only non-sandbox records, so I use the following:

SELECT Auction_Number, Auction_ID

FROM Auctions

WHERE Auction_Status = 'Current' AND Sandbox <> 'Yes'

and I get 0 records returned!? Any information on why this happens would be greatly appreciated. Thanks!

[fmsavey]

Are there records with "No" or are they null? If they are null use "... AND Sandbox is null"

If there are records with "No" how about trying "... AND Sandbox != 'Yes'".

[Wim Decorte]

wouldn't ... AND Sandbox = 'No'

be a lot simpler :)

[angelleye]

No, becuase they don't equal No unless they were set to Yes and then back to No. that doesn't happen.

fmsavey's suggestion works great. thanks!