Okay then, let's take this one step further.... If my DB has 2 table (many to one), such as product---<options linked on product ID. Can anyone think of a way to create a view that will show the option row for a given productid as a single delimited list? Jonathan McGuire ----- Original Message ----- From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 14, 2000 8:06 AM Subject: RE: SQL 7 > > Is one able to create a comma delimited list in a SQL 7 column. > > If so, is = > > this the best solution versus, adding a row. If not, what is the most = > > efficient way to distinguish the information between two identifiers. > > If I'm understanding your request, you want a denormalised list in a field - > in which case, just use a Text field or a Varchar field. > > You can put anything you want into those fields, so it can easily contain a > comma separated list. > > If you want to hold 2 lists for 2 different fields, then store 2 different > lists in 2 fields - there is no reason to hold them in one field > > There are problems with denormalised lists, but for small amounts of data > they are fine - I would suggest moving to normalising your relationships > though, it makes the system a lot more expandable. > > Philip Arnold > ASP Multimedia Limited > T: +44 (0)20 8680 1133 > > "Websites for the real world" > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > ********************************************************************** > > > -------------------------------------------------------------------------- ---- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.