FPD/FPW don;t have it, but query will work.
>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
>>>
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.