To all,

Back again! From one issue to another but you're help has moved me forward.

I created a Table in SQL Server 2012 with a character field set to "Not NULL". NULLs have been giving me issues in searching. I get and error: 'Cannot Insert Value NULL IN Column field cSteinLoc. Column does not allow NULLs.' I checked to see what SET NULL is in VFP and it is OFF. It seems to be trying to Insert a NULL value into fields. Even when I use a default of ' ', it still inserts the NULL???

Does anyone know why this is happening and how I can prevent VFP from placing NULLs in empty fields when creating a new record?

Thanks,

Bill