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


Yes, because ...

In the Access table one of the columns (fields) that i want to use
is a numeric field (double or long, for example). in this column,
it may or may not have .null. values in the access table.

if none of the (access) rows have .null. values in this (numeric)
column, the corresponding column in my vfp remote view will be
created as a numeric field. if there are (some) .null. values, my vfp
remote view will be created as a character field.

is it possible to force the corresponding column in the vfp view
to be numeric and default to a certain value in the view, if the
access value is .null. ?