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
>>>
--sb--