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