Posted by kingskippus on 10/28/06 18:54

--CELKO-- wrote:
> Why do
> you wish to destroy First Normal Form (1NF) with a concatendated list
> structure? It is the foundation of RDBMS, after all.

Maybe, but what I need is a column that returns a string that is a list
of items in a separate view. The goal is to make things easy on the
end users of the data. If they want to iterate over the list of items
and customize the way it's presented, they can. If they just need a
quick list of the items, they can get that, too.

Sometimes there is an ideal way to do things assuming that your users
have the same tools you do at their disposal, and a real-world way
where you have to answer to the demands of what your users really want.
;-)

[Back to original message]