>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 ?
>
Try to set before conversion

SET ANSI_PADDING OFF