Thank you Sergey.
>>Hi all,
>>
>>Is it possible to SELECT myField, substr(myMemo,1,254) as myChar from myTable?
>
>Yes, but you would use PADR() function because SUBSTR() doesn't guaranty the size of the field.
SELECT myField, PADR(myMemo,254) as myChar from myTable
ramil
~~ learning to stand still