When I first saw this question, I hadn't used the CONCAT function so I read up on it. I should have gotten the question right based off of that information but I wanted to verify so I ran the query. COLLATION ERROR!! When I re-ran within the context of the tempdb, success. Unfortunately by then I had already failed the QotD. My only excuse: I sooo need to wait for my first cup of coffee to take effect before trying to think...

Great Question!