Am I retarded or should these queries show the exact same things?

[aeroswat]

I just recently started using the IN keyword so I don't know if that has something to do with the fact that the first record set is showing 1 more record than the second one. The first I am getting 166 while the second is only getting 165

 

SELECT * FROM tblOrders WHERE Filled=0 AND (FormatNeeded='AU' OR FormatNeeded='ET' OR FormatNeeded='LP' OR FormatNeeded='BR' OR FormatNeeded='PR' OR FormatNeeded='NR') 

 

SELECT * FROM tblOrders WHERE OrderNumber LIKE '%%' AND StudentNumber LIKE '%%' AND AuthorizingName LIKE '%%' AND AuthorizingPhone LIKE '%%' AND AuthorizingEmail LIKE '%%' AND SchoolSystem LIKE '%%' AND StudentGrade LIKE '%%' AND BookTitle LIKE '%%' AND SupplyAPH LIKE '%%' AND SupplyAmt LIKE '%%' AND BookSubject LIKE '%%' AND Copyright LIKE '%%' AND ISBNten LIKE '%%' AND Publisher LIKE '%%' AND FormatNeeded IN ('AU','ET','LP','BR','PR','NR') AND Compatible LIKE '%%' AND YearNeeded LIKE '%%' AND OrderComment LIKE '%%' AND Filled LIKE '%0%' AND ShipAttention LIKE '%%' AND ShipAddress LIKE '%%' AND ShipName LIKE '%%' AND ShipCity LIKE '%%' AND ShipState LIKE '%%' AND ShipZip LIKE '%%' AND DateOrdered LIKE '%%' AND ShipDate LIKE '%%' AND Cost LIKE '%%' AND Code LIKE '%%' AND AIRCBNum LIKE '%%' AND ItemNum LIKE '%%' 

[aeroswat]

Figured it out. I had a field that was null so the %% wasn't picking it up