Re: Break a record up into several record

Do a substring that returns each part of the text and union all them together

select id,1,substr(my_text,1,20)
union all
select id,2,substr(my_text,21,20)
union all
...

If this is text, you can make it break at spaces.

The problem is that you will get rows for items that do not need all the rows.
You can handle that by selecting where text is not null in the view.

In 4.5 you can wrap lines and embed line returns in text so you wouldn't need to do this.

Paul Dorsey
Dulcian, Inc.

> If it is possible I want to create a view to that does this function,
> so i can use this view in a mutil-record block. (forms30)
>
> So if the contents of a record of the long_table is
>
> 1,'1234567889012345678890123456788901234567889012345678890'
>
> the view contents must be
>
> 1,1,'1234567889012345678890'
> 1,2,'1234567889012345678890'
> 1,3,'12345678890'
>
Received on Sun Nov 09 1997 - 00:00:00 CET