>>I think I understand what you mean now. If result datatype was a memo then trailer wouldn't occur ( or if you specify size with convert(char(4),year(adddate)), str(year(adddate),4) )
>>Specifying the size would work for you here since you know result would always be 4 (at least for our lifespan)
>>Otherwise you could prevent trailing forcing the datatype to memo.
>>
>>
>>cursorsetprop('UseMemoSize',1,0)
>>SQLExec(lnHandle,'SELECT LTRIM(STR(YEAR(AddDate))) as cYear FROM News')
>>? cYear+'A'
>>
>
>Running with this property generates the result to be dumped into a memo field. Isn't there a way to have it trim in a character field?
Not one I know.
Cetin