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