How to split content into multiple pages?

[lizok]

hello everyone!
i have row of data (article to be exact). Content is tores as "text 16" in sql server. So 1 article=1 row returned.
Those articles tend to run on and on. i'd like to split (span) into multiple pages with Page 1,2,3,4... as navigation links.
any advise on how to do it best?
BTW, thos are cfm pages that are converted to HTML for after loading. so i can't do iframes.

thank you

 

[MsChelle]

Are the articles stored in a single text field? How is the content broken up? Are there logical breaks? How do you want to define where to start a new page?

Maybe something like a series of mid functions with imbedded finds (for the breaks) could work? Or you could put it into a dynamic array with a break delimiter and control it that way.