This has no impact on memory. Your problem will be using SPT because you will not be able to specify to return varchar fields as memo fields. You can specify the data type to be a memo field if you have defined a remote view in a DBC so that when you open that view, the structure is created before you bring across data. SPT does not allow you to do that.

>When working with Cursors does this affect memory?
>
>When creating the Oracle tables I used all varchar2 field types rather than char types. The reason is that when you allocate that a char field is 200 characters the value stored in that field ALWAYS has a length of 200(trailing spaces are always present).
>