uses the STUFF function, more concise than using CASE
full interview on Red Ice Radio http://www.redicecreations.com/radio/2013/05/RIR-130526.php