Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.NULL. date values
Message
From
31/03/2000 14:22:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
.NULL. date values
Miscellaneous
Thread ID:
00353537
Message ID:
00353537
Views:
45
I am looking for a way to remove null values from date fields when I select fields from the ORACLE server and store them into a cursor.
I know I can do :

NVL(CUST.USER_CUST_NO, ' ') AS USER_CUST_NO && Puts a blank instead of .NULL.
NVL(SALES_ORD.LN_TOTAL, 0 ) AS LN_TOTAL && Puts a value of 0 instead of .NULL.

But what about dates??? How do I get an empty Field instead of the .NULL. ???

TIA
MIKE
Next
Reply
Map
View

Click here to load this message in the networking platform