using select to concatenate into a string?

From: <kimberly.shaffer_at_gmail.com>
Date: 21 Jul 2006 11:33:01 -0700
Message-ID: <1153506780.865682.82470@h48g2000cwc.googlegroups.com>

dilemma: using a select statement ONLY

is it possible to get the results to concatenate in a string such as?

select field from table;

original results

---

1 cat
2 dog
3 mouse

wanted results

---

1 cat, dog, mouse Received on Fri Jul 21 2006 - 13:33:01 CDT