>>I'm using the following code to trap empty dates coming into the stored procedrue from VFP call. Before I send the parameters in SQLexec(), I change the empty date from {//} to ''blank. I test about 10 dates before issuing the UPDATE. Relying on the default 1900-01-01 seems scary to me. Is there a better way?
>>
>>

>>if @ORDDATE  = '1900-01-01 00:00:00.000'
>>   begin
>>      set @ORDDATE = null
>>end
>>

>>
>>Thank You for your input!
>>Jeff Hart
>
>Hi Jeff,
>
>Why don't you send Null instead of empty date from VFP?

Because, I'm a meathead! I need to start thinking here.

Thanks Sergy
Jeff