created a database and in that, created a remote view (odbc) to
an access97 table.

when i browse the view, i can see all fields ok, but the fields
in the access table that have .null. values show up in my view
as character fields with value ".null."

how can i substitute a given value in this case ? (e.g. set
the value to 0 if the access field is .null.) ??