Strange, Query and data look good but not all returned

[dalec]

I have a pretty straight forward query:

select * from MyTable where cancelled = 0

Not all the the data that matches the query is returned, it was fine and no changes have been made, it just stopped returning all the possible matches, any ideas?

If I use the query anylizer on the specific records it's missing they look OK.

Thanks in advance,
Dale

 

[gmmastros]

Could it be a NULL issue?

select * from MyTable where IsNull(cancelled, 0) = 0

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[dalec]

I'll try that, but, looking at the individual records they have an actual zero.

 

[TheBugSlayer]

Hmmm...have you or anyone executed SET ROWCOUNT?

 

[dalec]

Well, well... Thanks to everyone for your help, but, after I traced through my code, I found that I had a counter on the maximum records and that was the limitation. It was a real stumper till I found it.