Eliminating too many record??

[#1]

$(qvd_name)

load
[Loan Number],
[Loss Mit Status Code],
[Servicing Sold Id],
[Referral Code]
FROM
(qvd)
where
[Loss Mit Status Code] = 'A'
and not Match([Servicing Sold Id],'NSM120110');  /*I am only trying to eliminate records having this Servicing Sold ID here.  Instead I seem to eliminate far more.  When I comment out this line of code I get 4000 records.  When I include this code I only get about 147 records.  Any ideas why?*/

[ecolomer]

Try have all the records first and select only these you wont

Select only records selected and count it and compare

It is possible you have any problem with the relation inter files

Saludos,

Enrique Colomer

[#3]

Actually after some "poking" I found the answer

where [Servicing Sold Id] <>'NSM120110'   seemed to work.  still a little new at this