Isn't IIF() reserved for MDX Analysis and not common T-SQL?
>>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.
>
>Dan, what you really need to do is get to know the built-in SQL2K functions. Look at ISNULL (check_expression , replacement_value) as a substitute for NVL(). SQL has an IIF() function which is the same as VFPs, and also a CASE statement for inline evaluaitons.
- Jeff