Re: Break a record up into several record

G.Reulen wrote in message <644kp2$cqg17_at_easy4.worldaccess.nl>...
>Hello everyone
>

I think this will do it - one way anyway

Create view as Long_View
SELECT ID + .1 ID, substr(txt,1,20) txt from long_table UNION
SELECT ID + .2 ID, substr(txt,21,20) txt from long_table UNION
SELECT ID + .3 ID, substr(txt,42,20) txt from long_table Received on Thu Nov 13 1997 - 00:00:00 CST