>Yes, I believe the maximum is 255 characters. Try this:
>
>SELECT DISTINCT LEN(ALLTRIM(MyMemoField)) AS length FROM MyTable ORDER BY 1 DESC
>
>to see the individual lengths...may that one record is much longer than the others....
ok... that work good...thanks..rob