If both variables are set to the same size it will work fine. That would be the ideal case for using the function. It simply takes the variable,...

When you rate SSC articles, there are five possible star ratings: awful, poor, average, good, and excellent. I went for poor, on the basis that it isn't awful, but...

I agree, COALESCE does have issues when nesting queries. If you decide to use the function it's probably best to select the case statement into a variable first and...

Not only is it documented behavior, but expected behavior. As a replacement value it only seems logical that it would replace the value in the variable, and not replace...