Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Annoying SQL Query
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00435486
Message ID:
00436309
Views:
23
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform