I am converting my VFP data to SQL Server and I noticed that fields that are blank in my vfp tables are coming over to SQL Server and the blank
fields from VFP are taking up space in the SQL Server data set, I went through some of the tables and set the empty fields to null and noticed the data set file size dramatically decreased. Is there a way for me to prevent this from happening automatically without having to go through each field and set the values to null ?

Thanks for you help
Stephen J. Hunt