[RESOLVED] MS Sql Server - not filtering on Null?

[Ecniv]

Hi,

Got a weird one. I have two simple sql statements.

select top 10 * 
  from tablename
 where idfield is null
 
SELECT top 10 
       pb.*
  from tablename pb

The first returns no records.
The second returns ten records, of which the idfield is null.

Any ideas why MS Sql server isnt filtering correctly?

[Ecniv]

Found it

The first I had pointed to a view (which got rid of nulls) the second was the table. Both had very similar names. Not ones I created, but I should have seen it.

All sorted and makes sense now.

[jmcilhinney]

This is an example of why it's a good idea to post the actual code if you can. Simplifying things can have its benefits but, as we're not as close to the problem, I'll wager that we'd have noticed the different names immediately, if those names had actually been posted. If a simplified example seems warranted, I'd probably recommend that in addition to the actual code, rather than instead of it.