Hi everybody, I'm having a database named "items", inthat one field name is "itemname" and the contents of that field is as follows....
Monitor 15" - LG Monitor 17" - Samsung Keyboard - TVS Monitor 15" - Samsung Mouse - Genius Keyboard - Microsoft .... .... The first part is the component name and the second is the Company name I need to have the distinct components in this field...like this Monitor Keyboard Mouse Any help would b greatly appreciated.... Thanks in advance, /sagar