Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Re: String Problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-09 : 22:45:28
Asif writes "I am trying to pull data into a combobox from a field which has subcategory information about products.

The data in the field is as follows sub categories in somefields are separayted by |

Field01

HP LaserJet 5000 |HP LaserJet 8000
HP LaserJet 8000
HP LaserJet 8150 New Product
HP P405 Dot Matrix
HP Peripherals Accessories|HP LaserJet 8150 New Product

I want the data in the combobox to be group so that i do not get repeated values as follows


HP LaserJet 8000
HP LaserJet 8150 New Product
HP P405 Dot Matrix

many thanks"
   

- Advertisement -