>>>On a side note is calling functions in the select clause in Sql just as costly as in Fox?
>>
>>Yes.
>
>I disagree.
>
>If functions are written well and are optimized, they can be very efficiently used in SQL Server queries.
>
>I've written very complicated reports that used functions (many that are compounded - function calling function) for almost every column of report data that are extremely fast (much faster than could have been accomplished in VFP on a subset of data that didn't exceed VFP's capacity).
>
>The functions have to be tuned well, otherwise yes - you'll have crappy performance.
There's a lot of overhead on a call to UDF itself which cannot be eliminated by any tunning.
--sb--