>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?