>>>>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.
I'm sure there is a fair amount of overhead, but it doesn't seem to add a lot of time when processing from what I've seen (assuming the functions themselves are fast).
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________