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