>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.

Not without creating a UDF to concatenate the strings. It might be easier to use SCAN...ENDSCAN to loop through the records and build the new string.