>All of the VFP date fields and the SQL datetime fields accept null values and there are null values -- both in the data that has successfully appended and in that which failed. How can I tell which one is being seen as a character value--or how can I tell empty from null?
Update myview Set mydate=.NULL. Where Empty(mydate)
Edward Pikman
Independent Consultant