>>Hi,
>>
>>Say I have a table with a char column that is set to accept NULLs. Then, from VFP using CA, I save a new record or update an existing record and the value in this column sent from VFP is zero-length string (basically empty string). The SQL Server then sets the value in this field to NULL. Do I understand that for SQL Server a zero-length string is not an entry that should be "considered" and therefore SQL Server sets the value to NULL?
>
>Your question is not clear. I think if you send NULL, SQL Server produces NULL. If you send '' SQL Server should produce an empty string.
Then I must be doing something wrong. I will recheck to make sure that I do send empty string. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham