>Hi
>
>We have a typical requirement. We use VFP and SQL Server 2008 r2.
>
>Say we have a sql table with 10 fields (Numeric, Char, Bit, Varchar(max) etc.) and they are null allowed.
>
>Our requirement is that how do we manage null. In our frontend interface form
>we will use textbox to accept the information. Each textbox will be initialise
>with either Zero, Space, .t./.f.
>
>The requirement is that if the user does not have a information for a particular
>attribute (field) then it should be saved as null in sql. But if he has the value
>then it should save that value in sql. Even zero can be a valid value.
>
>In all other case we should be able to save the record as null.
And what is the question?