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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.