>>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.
If it's not broken, fix it until it is.
My Blog