>>>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.