Sequential Record Update

Question

Can a SQL script be written to sequentially go through all the records in a table and, based on certian criteria, copy text data from a specific field and concatinate the text, in the order found, into a field of one record in another table?