Hi Julie,

If the size of your memo field is limited you can use varchar data type wich can be up to 8000 char long ( with record lenght limit of 8080 bytes).

>We have some really long memo fields(size 1586-3106) and are having difficulty converting it to SQL via DTS job. What is the best way to fine tune SQL to accomodate this?
>
>Thanks.....