<ReevesSm...@discussions.microsoft.com> wrote:
> Switch
>
> Hard to say on performance, SQL will probally be faster in that it can
> restrict your set before it sends, but if you are talking about small sets I
> think it is very minor.
>
> Reeves
>
> "Chris Patten" wrote:
> > Is there a sql equivalent to CASE in srs expressions? I have a field which
> > can return a value of 1-10, and based the the value I want to display some
> > text. I know how to do the case in sql, but would prefer to do it in SRS if
> > possible as I have about 12 fields like this and don't want sql to get messy.
> > Thoughts?
>
> > Also, is there any performance hits doing it one way or another?