• I agree with Jeff. Or for that matter since this is just in the select list, that scalar function can be turned into a case statement very easily.