>Hi
>Can anyone help me how can programmatically change a field type from memo to character
>thanks
>bill

Could you use a combination of COPY TO ... EXTENDED and CREATE FROM?

Use COPY TO...EXTENDED to create a table of your fields. Find the memo field and change the data type to character. Then create a new table using CREATE FROM. You'll probably need to insert records one-by-one into the new table so it could be a time-consuming process.

Hope this helps,
Mark