SQL and VB.NET 2005

[tacoman667]

How would I insert values using a command string where one of the values is null but the field in the DB will accept null?

For example:

USE MyDB
INSERT INTO MyTable (Name,Description,Notes)
VALUES ('myName','myDescription',' ')

The last Value is null but I keep getting a truncated error when executing the command. Now keep in mind, not all of my notes will be null values.


Thanks in advance!!