Originally posted by Ed zhang:
But it really works well in sybase. I wonder if it's a bug of sqlserver.
If Sybase considers "NULL = NULL" to be true, it's a bug in Sybase. It's been a while since I've used it, but I can't imagine Sybase has changed to violate the standard rules of relational databases.
Of course, I suppose the Sybase
JDBC driver could be really clever and do automatic string replacements, but that seems like it would be a big hole to introduce other bugs.
[ January 06, 2005: Message edited by: David Harkness ]