hi!!, i was playing around with my QA and tryin' to find the perfect query to avoid this NULL issues. Of course, i still haven't found it.

I think this is like... try to explain what means nothing (in Real Life ).

SET ANSI_NULLS [Off | on]

DECLARE @val1 int

DECLARE @val2 int

If (isnull(@val1,null) = isnull(@val2,null))

    print 'True'

else

    print 'False'

SET @val1 = NULL

SET @val2 = NULL

If (isnull(@val1,null) = isnull(@val2,null))

    print 'True'

else

    print 'False'

Well i know this could not happen in real cases, but is curious how the result of this is always False, why??, i'm not expert in SQL Server but.. for SET ANSI_NULLS Off .. the result shouldn't be TRUE???

can anybody explain this??.. 

thanks!!