>Hi all
>I generate an excel file by running SELECT into a cursor, then COPY TO.... type XL5.
>Since memo fields cannot go to excel, in every memo field i used left(mymemo,254)...Now the customer requested more data to be retrieved from those memo fields, so i now replaced those with LEFT(mymemo,1000). When running the query now, i get error 1903 "string is too long to fit". How can i fix this?
>
>TIA
>Jaime

Jaime,

You can not create Memo fields using LEFT functions - you may try using CAST function, e.g.

CAST(left(myMemo,1000) as M) as ShortenedMemo, ...

In order to produce the file you may use approach outlined by Cetin Basoz Re: Exported date to Excel won't format as date Thread #1399348 Message #1399394