I want to see who can give the answer I want. Thanks First!... and now:

CREATE SQL VIEW myview ;
CONNECTION m.conexaodbc ;
AS SELECT CASE mydate
WHEN '19000101' THEN CAST('' AS DATETIME)
ELSE mydate END as mydate FROM tabdtof

1st

We need the default value, right!? so I want to download the data with my field 'mydate' as a blank date when it's equal to the defaultvalue '19000101'

2nd

How can I relate this expression ( wich I give the same name as the field ) with the field it self ? ... because I want to make a tableupdate() hoping this expression ('... as mydate ') updates the field 'mydate'

THANKS PEOPLE!!!