Hi!

This usually done by selecting values grouped by the key field, calling of the function inside of the select statement that gets the key, does the subselect, concatenate the result and returns a result to the main query.

However, I guess it is much better to do at the client side in the view. Scan the view and get values list in the cursor, concatenate them and fill the view's field that is not updatable...

With SQl Server I don't know if it is possible at all.

With Oracle there are functions too.

HTH.

>is it possible to create a view from one table that groups the output by a key, and that one of the output fields contains the concatenation of the text from all of the records in a given field? (similar to summing the contents of a numeric field)
>
>Jay