Read record from field

Let say I have 30 fields in a table.
How can I read a record that is either an integer or string data type in a particular field?
After reading the record, how can I append it to another table in another field after doing some algorithms?


Thanks
Andy Wong