Mike,
As in VFP, UDF calls in queries in SQL Server are expensive by itself. If query have those columns already, I would pass 24 parameters to avoid extra query. Anyway, you've to test different ways to find out which one works better for you.
>
>I should have also mentioned - does it change the solution if I am calling it for every row in a view? It could be called several hundred times in a row. Would it make more sense in that situation to pass in the 24 values that are already retrieved, or to use the solution as already posted?
--sb--