>I am moving from FoxPro to SQL and would like to know if this is an equivalent SQL function to FoxPro's IIF() and MIN()
>
You can replace IIF() with CASE function. There's MIN() aggregate function in T-SQL, the same as in VFP select. If you're refering to VFP MIN() function, as in MIN(a,b), than there isn't one in T-SQL , but you can easily get the same result with CASE function.
--sb--