Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nulls in SQL outer joins
Message
From
04/11/1997 07:13:36
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00058095
Message ID:
00058113
Views:
27
>In an SLQ result with outer join condition to a cursor the columns that don't find a match do get a .NULL. value, is there a way to have VFP put a 0 (zero) or spaces depending on the field type?

Hi Jorge,

The NVL() function should help you with this.

Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform