>
>I just ran a test. Took one of the date fields and replaced all values with .NULL. when empty. Then when I ran the upsize I took another date field and changed it from the default DateTime type to smalldate type. Results were that the date column I set to .NULL. had a value on SQL Server. The column I switched the default to smalldate on defaulted to 1/1/1900 when the field was empty. As long as I know it the behavior, I can compensate for it like you did. It just seems you should be able to control the SQL default better. Thanks for the response.

William,

Just FYI you can also set a default value for those fields if you like. That would, of course, presume that you had a way to know what those pesky dates should actually be!

Best,

Best,


DD

A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.