Thanks Cindy,
I'm currently reading up on T-SQL. I know I can do just about anything in SQL that I need (Didn't get to IIF() yet). I was just hoping for an easy solutions to switching views between VFP and SQL that wouldn't require me to maintain two versions of each. Probably more trouble than it's worth ... unless someone else has already done the work, of course.
Dan
>>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.