simple query

microsoft.public.sqlserver.programming

12 Dec 2006 8:17 AM

Mr. SweatyFinger

SELECT     CategoryName
FROM         ads_categories
WHERE     (adnum = 12)

returns 3 rows:

      Catering
      Cleaning
      Concierge

yet i want it to return all the rows in one bite with a <br> thrown in
      Catering<br>Cleaning<br>Concierge

MAKE IT SO!