Return a delimited list from resultset

[jerasi]

I have the following query:
Select iCategoryID From tInventory WHERE iManufacturerID=1 Group By iCategoryID
This query return IDs 10 11 12 and 13
Is there a way I can get these IDs returned to me as one field i.e. "10,11,12,13" AS myIDsList?

Thank you.

Let me put it this way:
While StressLevel Is High
Productivity -= 1
Marriage = Nothing
End While

 

[tokuzumi]

Try this: Looks to be what you may need:

http://www.sqlteam.com/item.asp?ItemID=256