Is it possible to "sum" the contents of a character field within a SELECT - SQL command. i.e. Say I have 3 records with a field called fruit, with values of "apple", "pear","banana" - can I produce a cursor that contains a sumation field containing "apple pear banana"?

Thanks in advance.