Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Please no Null in my select SQL result...
Message
De
23/07/2001 15:32:53
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00534045
Message ID:
00534049
Vues:
12
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform