Patrick,

First, are you sure you want to do this? Null values are perfectly valid values. You can use ISNULL() to determine if any given field is null or not. If it's a display only thing you can use the SET NULLDISPLAY to control how the user sees a .null. value.

>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.) ??