>>>>I used ISNULL in my answer too (I embed the answer inside, may be you didn't notice). I just wanted to list both functions in my answer for the reference.
>>>>
>>>>BTW, on the SQL Server interview I was asked about the difference between these two functions and since I didn't use SQL Server that much I was unable to answer (if, of course, you don't consider "I can always check the details in BOL" as an answer ) :)
>>>
>>>
>>>Why not?
>>>For me that is a pretty legal answer.
>>>BOL and VFP HELP are always open on my desktop :-)
>>>The main point here is that you know WHERE you must search at first place ;-)
>>>
>>>When I answer like this:
>>>Check SomeFunction in BOL
>>>
>>>And I get this as return:
>>>What the f..k is BOL?
>>
>>If you know what to search, then BOL is the right place. Say, I vaguelly remembered about QUOTENAME() function (haven't used it recently), so I was able to find it in BOL without remembering its name.
>>
>>But usually on a generic question I prefer to JGI.
>
>What is JGI?
>(I suspect it is somehow related to Google, but...)
>:-)
>
>
>
>Update: FOUNT IT :-))))))
>Just Google It :-)))))))))))))))
>Yep, Google is my best friend.

I just usually omit the F word :)