If you create your table using column defaults of '':

CREATE TABLE [myTable] (

 [column1] [char] (10)  DEFAULT (''),

 [column2] [char] (10)  DEFAULT ('')

) ON [PRIMARY]

GO

any insert that would produce a null value...