have you tried to assign NVL(a,"") where a is the value that might be .null. ?

>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