Remove ALLTRIM().
>
>I have a table with three memo fields in it. When I issue a select statement to return all the memo fields it returns the first memo fully, but the second and third memo returns only one charactor. Is anybody know about this? or am I missing some thing here. Please help me.
>
>The command I was using is
>
>select alltrim(memo1) as memo1, alltrim(memo2) as memo2, alltrim(memo3) as memo3 from Sample into cursor csrSample
>
>Thanks.
--sb--