I'm another advocate of the "Stored Procedures" only group, however, pragmatism has a place and there may be specific instances where in-line SQL is the answer, however, those instances should...

Wish I'd thought of that 🙂

Case of the missing STUFF command, but the pattern was immediately recognisable. Better proof reading of the questions needed?

Jason, Many thanks, worked perfectly, just what was needed 🙂

Hugo Kornelis (7/29/2013)

---

I like the question. I don't think it's a trick question - many people here are so used to using case insensitive collations (stupid defaults!!!) that they can...

Good question - Had to think hard about that one...

Good question, made me think as the obvious answer seemed to obvious... It's the little things that trip us up. 🙂

Ho-Hum Question about one topic, answer about another.... Explains why i got it "wrong" Seems to me however, that it is the published answer that is wrong for the question.......