We don't go to vfp9 for a while, so can't use that, I thought about though.

I need the action_not memo field to show up in the resulting cursor or table as a memo, in this case. If I run the select without the distinct keyword and now function around the field, no problem.
but if I put the distinct and function around the field, I get the error, sting too long.

the function can be either my UDF fixmemo, or the alltrim function.


>If you would be using VFP9 you can use new CAST function to get memo field. Also I don't understand why do you need this FixMemo function at all. If it's empty, then it would be empty in the result, if not - would not be empty. What is your goal for this select?
>