I know it's common practice in VFP to not allow nulls. I assume this is also the case in SQL server. My problem is that when I do an SQL INSERT to insert a blank record for editing, any field left 'blank' is actually null filled and the insert fails. Two solutions come to mind. 1. Set a default value for each field in the SQL table (or VFP remote view). 2. Cycle through the record checking for nulls. Is there a better way? Should I allow nulls?

TIA

John