One thing you will see is that you would give your right leg to have an T-SQL equivalent
of IIF(). NVL() it has: ISNULL().

>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