Rune Bivrin (1/10/2017)
Russell Shilling (1/10/2017)
The answer is clearly wrong. Some of these questions are really questionable.The
isnull(left(@b,3),'I ô Char') as ba
will also return the string. The left function of @b-2 returns NULL.
Well, if you'd run the code you'd find it's completely correct.
What's missing in the explanation is the behaviour of ISNULL(). It always derives its return type from the first argument, which in the "ba" case will be char(3) as that is what LEFT() will return.
+1
The question itself I thought was a great question but the explanation skipped the important part about the return datatype from ISNULL.
I look forward to the next question from Tejinder and hope the explanation is as good as the question next time.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/