Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news.tiscali.de!newsfeed.hanau.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!b28g2000cwb.googlegroups.com!not-for-mail From: "Dave Conrad" Newsgroups: comp.databases.theory Subject: Re: Gray Hair is still relevant Date: 19 Jul 2006 10:41:17 -0700 Organization: http://groups.google.com Lines: 27 Message-ID: <1153330876.970968.198030@b28g2000cwb.googlegroups.com> References: <1153147952.877120.99030@p79g2000cwp.googlegroups.com> NNTP-Posting-Host: 38.115.151.134 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1153330882 10599 127.0.0.1 (19 Jul 2006 17:41:22 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 19 Jul 2006 17:41:22 +0000 (UTC) User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.4) Gecko/20060508 Firefox/1.5.0.4,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: b28g2000cwb.googlegroups.com; posting-host=38.115.151.134; posting-account=VdLGWQ0AAAD_lGGQYAUIi9HedigZxWKG Xref: dp-news.maxwell.syr.edu comp.databases.theory:43465 Tonkuma wrote: > CREATE TABLE Users > (Name VARCHAR( 10) NOT NULL PRIMARY KEY > ,Categories VARCHAR(100) NOT NULL > ); > > INSERT INTO Users > VALUES > ('Joe', 'Engenner|Tester|Engenner|Sales|Engenner|Project Manager') > ,('Ann', 'Secretary|Technician|Engenner|Technical Manager|Sales > Manager|Technical Manager') > ,('Pak', 'Sales|Engenner|Project Manager|Engenner|Project > Manager|Sales') > ; > > Pak Sales|Engenner|Project Manager > > Joe Engenner|Tester|Sales|Project Manager > > Ann Secretary|Technician|Engenner|Technical Manager|Sales > Manager > It's always nice to see a solution from a real Engenner. -- This message has been brought to you by the letter pi and the number pi.