Hi,
My problem is as follows: I have data entered into a varchar(500), and I would like to split it up into chunks of ,say, 50 characters. Actually, to be very precise, I would like to sense when a paragraph is finished, and then make that one chunk, and then the next paragraph is the next chunk, and so on.
Also, I need to extract the first element of the varchar field.
So for example, using the above paragraph, I need to extract the "M" as the first chunk, from the word "My"
Then I would like the next chunk to read from "y" to the full stop at the end of "... and so on." (maybe indicated by the presence of the vertical space?)
and then the third chunk would be "Also, .... field."
Any help would be graciously appreciated. (I will name my second child after you, as apparently, my first one belongs to Rodney from this board 😛)
