Null value and MSSQL

[Andy Jones]

I am creating scripts that convert data exported from Filemaker and write them to a MS SQL Server DB. If a particular field contains no data I need to insert a Null value into SQL Server, but I am having difficulty doing this as I cannot seem to find documentation on how to insert a Null value writing a SQL statement passing values in variables or elements in an array. Is this possible?

Hope this makes sense.

[Cups]

Not sure about MSSQL, but shouldn't you set the default value to NULL at the table level?

This sounds as if it is probably more of a general sql question.

How are you moving the data from one to the other.