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.
Received on Wed Jul 19 2006 - 12:41:17 CDT
