Thank you, Kamal, This sounds like what I need, and I will give it a try..
Chen
>Hi Chen,
>
>Have the field on SQL Server accept nulls and store a null. You can control the interface easily. I could not find another way out in SQL Server 6.5.
>
>>In VFP, I can insert {//} as a blank date value into a datetime field.
>>What is the same thing for SQL Server 6.5? I can insert '' into SQL Server datetime collunm. However, the '' turns out to be {01/01/1900}, which is not what I want. Help please!
>>
>>Chen
Chen Nan