>I need to change an existing memo field to a character field because the client now needs to be able to sort on that value. The size is not a problem because the longest value is about 75 characters. When I change the datatype all values in the memo field get lost. What is the best way to handle this (VFP5)?
>
>Thanks.

Add a new field with the right width, and then Replace all yournewfield with yourmemo. Then you delete the memo field afterwards.