>Sorry Sergey, It is Memo and Charecter field.
>
>Want to copy data from memo field(Comments) to Charecter field(comm_text)
The following command will copy contens of Comments field to the comm_text field for each record in the table. Keep in mind that text will be truncated if it exceeds the size of comm_text field.
SELECT mytable
REPLACE ALL comm_text WITH Comments
--sb--