hi,
i should have put in the complete original query!

select mline(memo1,1) as "description"

by changing this to

select padr(mline(memo1,1),100) as "description"

it works just fine. it didn't work with set memowidth to 50 and set _mline = 50 though!
Slán
~M


>MLINE() is depend on SET MEMOWIDTH TO n, you can use ALINES().
>
>MartinJ
>
>>hi all,
>>i have a problem with a memo field, its contents are below (please don't mock my test data!).
>>
>>aMarks testing kokokoko1
>>bline 2
>>
>>When i do the following
>>

>>SELECT MLINE(memo1,1) as "Description" FROM sub_table
>>

>>i get "aMarks testi" returned. if i set _mline to 50 and run
>>

>>SELECT MLINE(memo1,1,_mline) as "Description" FROM sub_table
>>

>>i get "n". What ultimately i need to do is
>>

>>SELECT MLINE(memo1,1) + " " + MLINE(memo1,2) as "Description" FROM sub_table
>>

>>but i cannot even manage to get the first line of the memo filed out.
>>I have hit this before but i cannot remember how to remedy it, any help gratefully received.
>>Slán
>>~M