>>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.