Comma delimited values into rows

From: johnv <jverburgt_at_cme.com>
Date: 9 May 2006 19:37:37 -0700
Message-ID: <1147228657.310936.108380@j33g2000cwa.googlegroups.com>

I have this string in a field called 'ID':

1000,1001,1002,...n

In sql only, how can i write a view that treats the comma as a new row so that my result set reads as:

ID

---

1000
1001
1002 Received on Tue May 09 2006 - 21:37:37 CDT