>I am transfering data from Access to VFP with ODBC.
>
>It woking find using remote view but some field that I transfer have Null value.
>Is there a way prevent having Null in my Select SQL Result?

A small addition to Steve and Hector's responses...

You'll want to insert, if null, a value equal to the length of the field.

VFP SQL Select bases the field size of the resulting cursor on the lengths of the first record. If it happens to be a length less than the field length, you'll end up with a truncated value.

Jay