>>>According to BOL: "We recommend that you not use time-dependent functions, such as RAND(), within a NULLIF function. This could cause the function to be evaluted twice and to return different results from the two invocations".
>>>My guess is the value that NULLIF() checks is different from the value returned because of that.
>>
>>Sergey,
>>where you found this?
>>I read all about RAND() and NULLIF() bud I didn't read anything like that.
>
>I found it in the NULLIF() topic (Remarks) in BOL 2005 online at http://msdn2.microsoft.com/en-us/library/ms177562.aspx. It also present in BOL 2005 on my PC. It's not in BOL 2000, though.

F***********!
(sorry about that)
But I thought I have SQL Server 2005 BOL installed because I install it with SQL Server 2005.
Thank you. I must find a way to know what is my last version of BOL.