>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
{} is an empty date.
Erik Moore
Clientelligence