Collect and show one type?

[Pheddy]

Hi All!
I have a product catalogue in MSSQL, now I would like to make a function that search the database and shows a list of each brands and how many rows the brand have been found.

Something like:
Acer (33)
Sony(15)
.. And so on..

Can anyone picture me the best way to do so?

Regards.
Frederik

[Rabbit]

You mean like a count grouping by brand?

SELECT Brand, Count(*) FROM Table1 GROUP BY Brand

[Pheddy]

Well yeah, but it has to be a function that search for any brands in the column "Brands" and then Counts how many of these there are. So I wouldnt need to specify which brands to count beforehand..

[Rabbit]

You don't have to specify which brands to count beforehand.

[Pheddy]

Guess i'm a little confused. Im not sure how to print the values?

[Rabbit]

You would probably just loop through the recordset and write the values.

[Pheddy]

I see now Thanks.