I have a vb program that inserts data into a database based on whats in the text boxes. Some of the boxes do not need data and can be left blank. The table requires a value and instead of having a huge if...else statement that populates the fields with zeros (where there aren't values) I would like a quicker way. Any ideas? Either database (SQL Server 7.0) or at the VB level. Just a pain in the butt.