Cathi,

If you recall a previous thread where I asked a question about inserting a NULL, I could never get the darn thing to work. I don't know if it's a bug or what, but I gave up on it.

~~Bonnie


>The SQL Server syntax for the insert statement is:
>
>

>insert into TABLENAME (FIELD1, FIELD2) values ('TEXT', NULL)
>

>
>If you are setting the value in a DataRow inside of a DataTable, then you set the value of the DataRow like the following:
>
>

>rowCustomer("ContactName") = Convert.DBNull
>

>
>
>>how to insert a null value to database (DB2,SQL Server) from vb.net ?