Thanks Imar for all of the help. The $64,000 question is exactly that. How does it get set to 12:00:00 am. Each of the fields is definitely set to NULL, so there is nothing to start with. I do a basic read using VB and a DataReader. I use a conditional statement(show in a previous part of this post) that only sets the value equal to the DataReader column if it is not NULL. So I really haven't got a clue. I have googled this till I'm blue in the face and haven't come up with a thing. I seem to vaguely remember a post about this somewhere, but can't find it to save my life.

Right. So you're saying that the Reader returns a time of 12:00? That is:

If Not IsDBNull(myReader("StartDate")) Then
    _StartDate = myReader("StartDate")
End If

will be hit, even when the field StartDate is NULL in the database?
Did you also try the IsDBNull method of the Reader object to test the NULL value?

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

That is correct Imar. I really don't know why this is happening.