>Cetin,
>
>You are right. I am now sending 'NULL' for empty dates. But when I get the data using SPT to populate my form the controls that hold the dates show with .NULL. in them. The only way I can stop this is with a sub query, but then I can't change any of the feilds values. Is there a solution?
See SET NULLDISPLAY command and NullDisplay property.
--sb--