>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