>Sergey,
>I made a test, but I thing the new way doesnt solve a problem.
>How could I return all the text that a memo field contais if it has a limit of 254 characters to return now ?
>The only way to solve this is get the record and make a new select just to call the memo field with all it contains, right ?

Peter,

Just wondering out loud...

If "DISTINCT" is the problem (as the docs seem to say (see "Behavior Changes...")), I wonder if a UNION might get you around it since the distinct is implied (unless you use ALL).

good luck

>
>Tia
>
>Peter