Thanks for easy and back to basic question 🙂

Thanks 🙂

Toreador (9/11/2013)

---

Dear Steve

Can you change the points system so that if someone replies pointing out an error and 8 pages of people have already replied pointing out the same error...

Hany Helmy (9/11/2013)

---

I am really amazed of the 16 people (as of now) who got it right! :w00t:

Hope one of them will post a reply explaining how he got the...

Just because of "Steppenwolf" having length 11. So insert statement is...

Thanks for back to basics. Good question 🙂

Hugo Kornelis (9/7/2013)The actual answer is "@X is now A<". That's because the author uses ISNULL instead of the recommended COALESCE. ISNULL does not follow the normal data type precedence...

+101:-D:-D:-D

+1 🙂

Easy and good one 😀

Thanks for start my day with easiest question 🙂

Good back to basic question. Thanks 🙂

Tough question for me. :blink:

Carlo Romagnano (8/22/2013)

---

In this case CONCAT also is faster than ISNULL(FirstName + ' ', '') + ISNULL(MiddleName + ' ', '') + ISNULL(LastName + ' ', '') + ISNULL(CONVERT(VARCHAR(3), Age),'')

Because...

If you already use CONCAT function then it's easy to you. Otherwise first you need to check about CONCAT function.

I love this function. It removes some overhead while adding multiple...