>>>>I once saw a download of VFP style functions for SQL Server. Can someone point to where I can find it again?
>>>
>>>See File #
27115. Anyway, what do you need them for?
>>
>>Thanks,
>>
>>Looking for some UDFs that may help. I don't like to re-invent when there is already something out there.
>
>Scalar UDF functions are slow in SQL Server. There are Connect items to make it faster. In general, if you can embed the logic into the query directly (say, using CROSS APPLY technique - see sample here
Parsing Address to individual components ) then it will be better than using scalar UDF.
Too Cool. I was not even aware that there was a CROSS APPLY command. I guess I need to read more and code less. :)
Greg Reichert