Actually I got cofused :)

IN MS SQL Server it's ISNULL function non NVL
ISNULL(Completion.StatusID,0) as Completed

>What do you mean?
>NFL() is included in Visual Foxpro since version 3.0
>

---

>>Hi!
>>
>>Correct, but not for all versions.
>>
>>>

---

>>>You can use NVL function to convert NULL value
>>>

>>>NVL(Completion.StatusID,0) as Completed
>>>instead of
>>>iif(IsNull(Completion.StatusID,0,Completion.StatusID)) as Completed
>>>