>Hi All -- Is there a way to get the distinct values of a memo field into a text field in a different table using ALLTRIM() that doesn't truncate all of the values to the length of the first record's value? I can do it by indexing on the length of the field, copying the data to a table while the index is in place and then using ALLTRIM(), but it's cumbersom. I know VFP9 just does it, but I'm constrained to work with VFP70.
>
You can use PADR(ALLTRIM(), 254).
--sb--