>>>>>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: FOUND IT :-))))))
>>Just Google It :-)))))))))))))))
>>Yep, Google is my best friend.
>
>I just usually omit the F word :)

Why?
It is essential :-)
When I JFGI "JGI" no results were found :-)
And I need to search www.urbardictionary.com
When I put "JFGI" in my friend the wanted result was on first place :-))))))