Under SS 7.0 The code fragment

[jfield817]

Under SS 7.0

The code fragment below produces a predictable error on our data since the query returns more than one record

select X from Tablename where
1 = (select X from Tablename)



[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

However not all of our servers seem to be generating
the error .... Any reason why the above code
fragment would not consistently blow up ..

Thanks
John Field