Tricky SQL even possible?

Basically, I've simplified down what I need from a much larger problem. I don't even know if this is possible. What I need is to be able to create a select that will look at a VARCHAR2 field (call it text_field) and generate a row for every 5 characters in that column. In other words, if text_field has 50 characters, I would expect to get back 10 rows which would be the numbers 1 to 10. If it has 100 characters, I would get back the numbers 1 to 20. Received on Mon Aug 08 2005 - 17:04:52 CDT