Hey guys, here is the astonishing behaviour of a query that returns the same records whatever be it the WHERE clause ... It is a simple table with "A" being "int NULL" no default value, no indexes, database just dbcc checkdb-ed. Compatibility level is 8.0, and the connection from QA is, as usual, with the set_ansi_defaults, and concat_nulls_yields_null doesn't to affect. select A from myTable where A=0 result is the same as select A from myTable where A='' the same result as select A from myTable where A=' ' ... same result as .....! select A from myTable where A=' ' but obviously different (thanks God) from select A from myTable where A IS NULL Am I becoming stupid by the second? Or that's just the way it should behave??