Thanks everyone,

Pretty much answered my question. UDF's would be more trouble than maintaining seperate remote-view and local-view DBCs.

Oh well.

>>Has anyone duplicated (or failed to duplicate) common VFP functions as SQL 2000 UDFs? Looks like a good way to easy the transition of VFP views which are littered with IIF(), NVL(), etc.
>>
>>TIA
>
>Hi Dan,
>
>Using SQL 2000 UDF's would slow down queries considerably because UDF would have to be executed for each row in the query. You'll have to think twice before going this route.