Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Please no Null in my select SQL result...
Message
From
23/07/2001 15:32:53
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00534045
Message ID:
00534049
Views:
13
This message has been marked as the solution to the initial question of the thread.
>I am transfering data from Access to VFP with ODBC.
>
>It woking find using remote view but some field that I transfer have Null value.
>Is there a way prevent having Null in my Select SQL Result?

You can use the NVL function:

select NVL(custName, "") as cCustName from ...
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform